Skip to Content
Former Member
Feb 18, 2008 at 08:57 PM

Large data through JDBC adapters - restart


We have a big file with more than 20000 records, that needs to be loaded onto database table.

Should we split the files into multiple messages (1000 records each) and try to insert into Database table? Or Should we insert all record in one stretch.

If we follow the first approach, how do we go about restarting the message if there are any insert failures?