ORA-08177 problem (Serializable transactions)

[tharris]

Hi,
I keep getting Oracle 08177 errors on "long" running transactions like initial inventory load and trial balance against all accounts. I have read a lot about the "initrans" parameter for a table but there is confilicting information. Is it OK to run the Oracle database in "READ_COMMITED" isolation rather than "SERIALIZEABLE" isolation with Compiere?

Thank you for your help and I am really glad I found this forum.
Tom

[red1]

Hi Tom,
Thanks for your compliments in the guestbook.

I m no Oracle fan, i mean ODBA, but from your message it seems to be a simple logical issue. In lieu of u getting more authoritative answers from the likes of www.searchoracle.com i will suggest u try both options on some backups. But seriously, searching in Oracle do come up with real answers. My humble apologies

red1

[neilg]

I understand they did some work on fixing the serialize access for this transaction issue on the new version of Compiere 2.5.2c, if I understand the question correctly.

[neilg]

A colleague of mine made these changes to DB.java (for 2.5.1g) and it appears to be working:

Code: Select all

             {
                 // if (s_connectionRW.getTransactionIsolation() !=
Connection.TRANSACTION_SERIALIZABLE)
                     //
s_connectionRW.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
                 // Martin to prevent cant serialize error
                 if (s_connectionRW.getTransactionIsolation() !=
Connection.TRANSACTION_READ_COMMITTED)
                   
  s_connectionRW.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
             }
         }