I'm experiencing a similar problem, and its really disappointing that no one has replied to this post!
We are getting a SQL timeout exception on DB2 (version 8.x): DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68; The exception occurs when two processes are run, the first process is a long running transaction that inserts records into a specific table. The second process tries to read from the above table, and gets the timeout after a minute (which is what the timeout is set to on our database). We are using Optimistic locking with version column, so as far as I'm aware, the table should not be exclusively locked until the transaction is about to be committed! Using: OpenJPA 1.2.1 Please HELP!!! -- View this message in context: http://openjpa.208410.n2.nabble.com/Under-what-circumstances-a-table-row-is-locked-exclusively-if-Optimistic-true-LockManager-version-tp581619p5162919.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
