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