webMethods select adapter service

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

1 Like

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

Hi Amruth

your Select adapter service is working fine with small data?

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