Like the large document handling of TN, if we can have similar large batch handling in JDBC select it will be helpful. The current option to set the Maximum Row in the select template provides very limited way to handle large sets of records, as it requires some form of programmatic intervention to create the iteration till max rows.

The other way of handling this situation, is taking the help of sql-cursor capabilities of database and iterate over a stored procedure.

Any other ideas to handle large batch of records is welcome.

Thanks,
Anand Gopalan