Split and send End of record in JDBC

[Former Member]

Hi Experts,

We have a interface in which Sender channel(JDBC) is picking the records from database and Sending it to Receiver Proxy.

I need to split the Records in batches and when all records are inserted Trigger the an End of File (EOF).

If there are 100000 Records I need to split it into 10 batches(i.e. 10,000 each ) and send the Data to Proxy.

After the 100000th record is picked I need to trigger the End of File.

So Thereby My Requirement is :

1) I need To determine the size of database and Split it into 10 batches.

2) when the Last record is Inserted I need to trigger the End of File(i.e. the last record of database)

3) Should perform this without the help of stored Procedures

Any Help is Highly Appreciated

Best Regards,

Sainath Chutke

[Former Member]

Created one more message mapping!!