Getting rid of SetRollbackOnly

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Getting rid of SetRollbackOnly

subhradeep bhatacharya
Hi All,
   
  What I found out is that whenever a SQLException occurs while inserting a row in database, ofbiz mark the transaction as setRollbackOnly internally. Now I have a batch service that will insert multiple rows in the database and even if some insertions fails that should not impact other rows.So suppose I'm committing after each 100 insertions and I got an exception after 60 insertions, ofbiz is making the transaction as setRollbackOnly and now I have no other way out except rollbacking the transaction. Also due to performance issue I can't commit after each insertion. So could anyone figure me out in which way should I proceed?
   
  Regards
  Subhra

 
---------------------------------
Do you Yahoo!?
 Everyone is raving about the  all-new Yahoo! Mail.