In my java code I have a Prepared statement ps_temp.
PreparedStatement ps_temp;
// loop
ps_temp.setString(1,'abc');
....
....
ps_temp.addBatch();
// end loop
ps_temp.executeBatch();
Now one of the records in the batch created a Unique Index constraint, which eventually lead to the whole ps_temp.executeBatch() to fail. Not even the good records in the batch are inserted into the table.
So, is it possible that if my Batch has some good and some bad records(which can cause integrity constraint), THEN AT LEAST THE GOOD RECORDS GETS INSERTED INTO THE TABLE ?
Thanks in advance !! Noman