JBoss Community

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

created by Sukumaran Raghavan in jBPM - View the full discussion

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

Start a new discussion in jBPM at Community