|
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.
|