Skip to Content
Former Member
Jul 30, 2009 at 05:40 AM

Splitting JDBC records.


Hi Experts,

We have a interface in which Sender channel is picking the files from database Receiver channel is posting the files into database, Both sender and Receiver are JDBC communication channels only here, the problem is at receiver side while inserting the files into one of the database plant its getting Timeout error. So we decided to Split the records and pick n post i mean for example if the data volume if 30000 files , then we can do that it will pick and post 10000 thousand for there any setting in JDBC channel to define RecordSetsper in FIle communication channle or is there any feasbility to write a select query that ..*Select * records from database..till count =10000.. Please Suggest possible solutions*.