Raja, You may have not hit that part of the code path before. It appears to be be a bug inherted from quartz job store implementation. I believe it should have been trying to set the isolation level to READ_COMMITTED, but it was setting to READ_UNCOMMITTED (whichis not supported by ORacle). Fixed in svn.
-mbs On 2/2/07, Raja Balasubramanian/MAXIMUS <[EMAIL PROTECTED]> wrote:
Hello, I got the latest code base. Compiled. Created a new Oracle Connection Pool. When I tried to deploy ODE, getting exception. " java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels" This is happening at JobStoreJTA.java Line#1293 I didn't get the exception in my old code base (Dated 1/16/2007) How to solve this? Thank you Raja -----Original Message----- From: Maciej Szefler [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 11:48 AM To: [email protected] Subject: Re: Using ODE with ORACLE and Geronimo 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 >
