webMethods select adapter service

[Amruth_Ruttala]

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

[Holger_von_Thomsen]

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

[atif (Muhammad Abdurrehman Atif)]

Hi Amruth

your Select adapter service is working fine with small data?

[ahmed_shabbir]

Hi Amruth,

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

Check below link, hope this may help you

Batch select with JDBC adapter

I want to select a large amount of rows (over a million) from a database table and process each row in a loop. Currently it is not possible to do this with a JDBC adapter service because there is not enough memory to hold a million rows. Therefore I somehow need to batch through the result set in order to be able to process all rows. Is this possible with the JDBC adapter or do I need to “roll my own” batch solution? Thank you, Ulf Licht

Regards,
Ahmed