RE: Problems while switching torque from mysql to oracle

Thomas Fischer <[email protected]> Wed, 20 May 2009 07:30:08 +0200
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <OF37FF58E9.BAF1E1B4-ONC12575BC.001DEAB2-C12575BC.001E3A93@seitenbau.net>
> 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 using Torque)
- Swamp uses oracle reserved words as table or column names

To see which one applies, you yould try to modify the logging configuration
(look for a file called log4j.configuration if log4j is used) and set the
log level to debug. Maybe this provides more insight.

    Thomas