<span style='font-family:Verdana'><span style='font-size:12px'><br />
Hi<br />
<br />
I am getting the below error while creating the ksession.startProcess() instance in multithread.<br />
i.e. two thread calling the ksession.startprocess() with the ruleflow as<br />
<br />
<img src="cid:20110704071254.28336maild0@gmx.com" /><br />
<br />
based on initial testing i identified due to delete or update sql operation the below is appearing. Please let me know how to solve this issue<br />
<br />
ERROR LOG:<br />
Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?<br />
Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?<br />
2011/07/04 11:20:06.475{UTC} [JDBCExceptionReporter : JDBCExceptionReporter.java: logExceptions: 100] [RMI TCP Connection(6)-10.50.53.32]: WARN: : SQL Error: 60, SQLState: 61000<br />
2011/07/04 11:20:06.475{UTC} [JDBCExceptionReporter : JDBCExceptionReporter.java: logExceptions: 101] [RMI TCP Connection(6)-10.50.53.32]: ERROR: : ORA-00060: deadlock detected while waiting for resource<br />
2011/07/04 11:20:06.475{UTC} [AbstractFlushingEventListener : AbstractFlushingEventListener.java: performExecutions: 324] [RMI TCP Connection(6)-10.50.53.32]: ERROR: : Could not synchronize database state with session<br />
org.hibernate.exception.LockAcquisitionException: could not delete: [org.drools.persistence.processinstance.ProcessInstanceInfo#8130]<br />
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:112)...... <br />
<br />
<span id="editor_signature"><span style="font-family:Verdana; font-size:12px">Regards<br />
Dhinesh Kumar V</span></span></span></span>