Raja, This looks like a deadlock issue. Also if you could, (a) set oracle's deadlock timeout to some short period (5 sec) and run to see what happens, or (b) query oracle's lock table once the system hangs and include the output. Also if you run with logging at the debug level (esp wrt to hibernate SQL calls), the output could be very helpful. Also, it'd be best if you file an issue for this.
Thanks, -mbs On 2/2/07, Raja Balasubramanian/MAXIMUS <[EMAIL PROTECTED]> wrote:
Hi All, I'm trying to use ODE in Geronimo with ORACLE 10g as back end. ODE in Geronimo with MySQL works like a charm. I have created ORACLE schema and created a connection pool for that and mapped in web.xml and geronimo-web.xml. ODE deployment went fine and BPEL deployments went fine. But when I invoke a process (which calls another web service), it just hangs. No exceptions, but waiting for something indefinitely. Anybody faced this problem? Could somebody show me how to overcome this? Thank you Raja
