> 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
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
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 (