Hi, I'm running into table lock contention: 2 sessions are blocking waiting for a blocked session (both an insert and a delete statement waiting on a select statement!). This doesn't make any sense to me, therefore, without even understand my application, can someone please tell me under what circumstances a table/row is locked exclusively if Optimistic=true & LockManager=version? A few facts: 1) My app doesn't acquire any lock explicitly through JPA or native queries "select ... for update", "lock table ...", etc. 2) I'm sure my app causes this contention. 3) It seems the table is lock in exclusive mode i.e. can only query, however, I can't verify this.
OpenJPA 1.0.0 Oracle 10g R2 Oracle JDBC 10.1.0.3 Thanks very much in advance, Frank Keywords: database hangs, lock, contention, deadlock -- View this message in context: http://n2.nabble.com/Under-what-circumstances-a-table-row-is-locked-exclusively-if-Optimistic%3Dtrue---LockManager%3Dversion--tp581619p581619.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
