[jboss-user] [jBPM] - Re: ORA 00060 - Deadlock while using Oracle + JBPM 5.2

[Sukumaran Raghavan]

Sukumaran Raghavan [https://community.jboss.org/people/suku_1983] created the discussion

"Re: ORA 00060 - Deadlock while using Oracle + JBPM 5.2"

To view the discussion, visit: https://community.jboss.org/message/733857#733857

--------------------------------------------------------------
Yes pushpak. 

the oracle tabes get into a deadlock because of a cascaded delete. The scenario does not occur in MySQL because it does not have the concept of foreign keys. 

Create the following index in the JBPM schema. this shlould resolve the problem. 

CREATE INDEX "JBPM"."IDX_EVENTTYPES" ON "JBPM"."EVENTTYPES" ("INSTANCEID");

Let me know if it solves your problem. Do post back. In case it doesnt help, dump uour stack trace. I will try to figure it out. 

Have a nice weekend. 
ciao
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/733857#733857]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120504/682a004a/attachment.html