webMethods select adapter service

[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