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