RE: Problems while switching torque from mysql to oracle

2009-05-19 Thread Thomas Fischer
> But now I am facing the next problem: > When I try to start a new workflow in swamp I get the error message: > java.sql.SQLException: ORA-00923: Schlüsselwort FROM nicht an > erwarteter Stelle gefunden The following possible reasons come to my mind - Swamp produces its own SQL (this is possible

RE: Problems while switching torque from mysql to oracle

2009-05-19 Thread Bullwinkel Axel
Message- From: Thomas Fischer [mailto:fisc...@seitenbau.net] Sent: Montag, 18. Mai 2009 16:57 To: Apache Torque Users List Subject: RE: Problems while switching torque from mysql to oracle > That line looks like this: > torque.dsfactory.swamp.pool.validationQuery=SELECT 1 This will no

RE: Problems while switching torque from mysql to oracle

2009-05-18 Thread Thomas Fischer
> That line looks like this: > torque.dsfactory.swamp.pool.validationQuery=SELECT 1 This will not work with oracle. Please change it to torque.dsfactory.swamp.pool.validationQuery=select 1 from dual Thomas - To unsubscribe,

RE: Problems while switching torque from mysql to oracle

2009-05-18 Thread Bullwinkel Axel
That line looks like this: torque.dsfactory.swamp.pool.validationQuery=SELECT 1 Axel -Original Message- From: Thomas Fischer [mailto:fisc...@seitenbau.net] Sent: Montag, 18. Mai 2009 16:01 To: Apache Torque Users List Subject: RE: Problems while switching torque from mysql to oracle

RE: Problems while switching torque from mysql to oracle

2009-05-18 Thread Thomas Fischer
gt; Datum: > > 18.05.2009 15:42 > > Betreff: > > Problems while switching torque from mysql to oracle > > Hi all, > > I am currently trying to switch an application which uses torque > from mysql to oracle 9.2 and I am facing some problems. > > The application is

Problems while switching torque from mysql to oracle

2009-05-18 Thread Bullwinkel Axel
Hi all, I am currently trying to switch an application which uses torque from mysql to oracle 9.2 and I am facing some problems. The application is the workflow management tool SWAMP from suse and it runs on tomcat. When I try to start it via my browser I receive the following error messages (