We have configured a distributed transaction in our application server and
we are using openjpa 1.2.1 and Glassfish application server. Although the default behavior of transaction locking must be optimistic,
it seems that pessimistic locking has been happened.
It is found that Row Lock contention happens in a specific table.
This is the exception :
java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock
Is there any property which has to be set related to XA transactions management for openjpa?
For your information, already all the following properties have been set.
You can try a plug-in string to lookup the TM in JNDI (the value is the JNDI name of GlassFish TM as per Google search)
3. <property name="openjpa.ManagedRuntime"
Following searching about this locking problem, we found that we should add two more properties for openjpa as listed below.