Hi, I have a requirement in my application. I have to insert about 1000 records into a database at a time. So i am using batch update(to avoid performance issue). Insertion will be done through stored procedure(MS SQL). I will not set auto commit to false because, out of 1000 records,if 10th record have wrong data,all the other records have to be inserted.Now the problem is,if insertion of 10th record failed,then all the first nine records are inserting succesfully.But from 10th to 1000th records are not getting inserted. But what i want is,if 10th record is having wrong data, then except 10th record all the other records(total 999) should get inserted.Can any one suggest me the best way to do this using JDBC - CallableStatement?
Let me recap: you started with an invalid display name 'D K' and then changed it to something valid. Now you have changed it back to something invalid. I'll close this thread and give you a chance to correct your display name.
Please note that we take display names very seriously.
subject: How to insert all the records except the failed one.