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.