I have a Java app that continuosly inserts rows into a single table. I need to mimick the SQL loader conventional path load functionality in the following manner:
1. Use bulk inserts in a single call (just to speed it up)
2. Put all rejected rows into separate "BAD" file
When I insert them one-by-one all is fine and I have all set up, but I do not know how to insert rows in batches and get back info which rows were rejected to put them into bad file. Is there any method of batching inserts and getting back Array of error-codes or something similar through JDBC?