Hi,
We have row locks in our Oracle 11g jBPM database. I am still trying to figure out what action causes these locks. What I have seen so far is that there is a blocking session in our database which performs this SQL:
DELETE FROM jbpm4_execution WHERE dbid_ = :1 AND dbversion_ = :2
select INST_ID, SID, TYPE, ID1, ID2, LMODE, REQUEST, CTIME, BLOCK from gv$lock where (ID1,ID2,TYPE) in (select ID1,ID2,TYPE from gv$lock where request>0); INST_ID SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK 1 139 TX 65548 37132 6 0 8804 1 1 104 TX 65548 37132 0 6 7450 0
<hibernate-configuration> <session-factory> <property name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="hibernate.connection.datasource">java:/JbpmDS</property> <property name="hibernate.format_sql">true</property> <mapping resource="jbpm.repository.hbm.xml" /> <mapping resource="jbpm.execution.hbm.xml" /> <mapping resource="jbpm.history.hbm.xml" /> <mapping resource="jbpm.task.hbm.xml" /> <mapping resource="jbpm.identity.hbm.xml" /> </session-factory> </hibernate-configuration>