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.bullwin...@systech-eu.com -----Original 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 not work with oracle. Please change it to torque.dsfactory.swamp.pool.validationQuery=select 1 from dual Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org
