IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

webMethods select adapter service

  • 1.  webMethods select adapter service

    Posted Thu November 17, 2022 05:53 AM

    Hi All,

    Im trying to use select adapter seevice and i need to fetch around 30 lakhs records.

    But the server is getting hung and im not able to fetch the records.

    Is there any limit on the select adapter service that it can fetch that much number of records.

    Can any one help how can we fetch large number of records.Im using simple Select Sql template


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: webMethods select adapter service

    Posted Thu November 17, 2022 07:18 AM

    Hi Amruth,

    please provide your wM version, JDBC Adapter version as well as DB Vendor and version.

    Are there any messages in server.log and/or error log related to this issue?

    Regards,
    Holger


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: webMethods select adapter service

    Posted Tue November 22, 2022 08:34 AM

    Hi Amruth

    your Select adapter service is working fine with small data?


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: webMethods select adapter service

    Posted Tue November 22, 2022 11:15 AM

    Hi Amruth,

    You can use custom sql and write custom sql query to fetch data.

    Check below link, hope this may help you

    Regards,
    Ahmed


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


Related Content