> 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
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
> 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,
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
A shot into the dark:
Is there a validationQuery in the Torque properties ?
If yes, did you change it to "select 1 from dual"?
Thomas
"Bullwinkel Axel" schrieb am 18.05.2009
15:34:57:
> Von:
>
> "Bullwinkel Axel"
>
> An:
>
>
>
> Datum:
>
> 18.05.2009 15:42
>
> Betreff:
>
> Problems whil
