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?