db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bullwinkel Axel" <axel.bullwin...@systech-eu.com>
Subject RE: Problems while switching torque from mysql to oracle
Date Tue, 19 May 2009 08:25:29 GMT
Hi Thomas,
it works so far and I am able to login to swamp.
Thank you for the quick support.

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

Could you give me a hint where I have to search for the cause? Is this a problem with torque
or with swamp? Are there sql statements passed directly from swamp to the db or are all the
sql statement generated in torque?

All the best, Axel!


Fax:    
mailto: axel.bullwinkel@systech-eu.com
-----Original Message-----
From: Thomas Fischer [mailto:fischer@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 not work with oracle. Please change it to
torque.dsfactory.swamp.pool.validationQuery=select 1 from dual

    Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message