Hi,
There was a problem with the oracle templates in the 3.1.1 release. See
http://issues.apache.org/scarab/issues/id/TRQS222 for details.
The solution is to use the oracle templates from 3.1 or from CVS
Thomas
"Dressler,Erik(externe MA)" <[EMAIL PROTECTED]> schrieb am
14.06.2005 07:59:52:
>
> hi!
>
> i had the same problem. are you using turbine, too? turbine allocates
> oracle-scripts in a special folder.
>
> i think torque is originally designed for open-source-databases (mysql).
> oracle has problems with the syntax of the generated scripts. you
manipulate
> them manually and run them in a sql plus window, too!
>
> greetz, erik
>
> > -----Original Message-----
> > From: Jon August [SMTP:[EMAIL PROTECTED]
> > Sent: 13 June 2005 23:03
> > To: Apache Torque Users List
> > Subject: maven torque:insert-sql produces errors with oracle
> >
> > when I do a:
> >
> > maven torque:insert-sql
> >
> > I get the following errors for each of my tables.
> >
> > [torque-sql-exec] [ERROR] Failed to execute: EXCEPTION WHEN
> > TABLE_DOES_NOT_EXIST THEN NULL
> > [torque-sql-exec] [ERROR] java.sql.SQLException: ORA-00900:
> > invalid SQL statement
> >
> > [torque-sql-exec] [ERROR] Failed to execute: END
> > [torque-sql-exec] [ERROR] java.sql.SQLException: ORA-00900:
> > invalid SQL statement
> >
> > [torque-sql-exec] [ERROR] Failed to execute: / CREATE TABLE
> > gd_position_rcs ( position VARCHAR2 (5) ) / DECLARE
> > TABLE_DOES_NOT_EXIST EXCEPTION
> > [torque-sql-exec] [ERROR] java.sql.SQLException: ORA-00900:
> > invalid SQL statement
> >
> > [torque-sql-exec] [ERROR] Failed to execute: PRAGMA
> > EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942)
> > [torque-sql-exec] [ERROR] java.sql.SQLException: ORA-00900:
> > invalid SQL statement
> >
> > [torque-sql-exec] [ERROR] Failed to execute: BEGIN EXECUTE
> > IMMEDIATE 'DROP TABLE gd_sales_unit_rcs CASCADE CONSTRAINTS'
> > [torque-sql-exec] [ERROR] java.sql.SQLException: ORA-06550: line
> > 1, column 74:
> > PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> > the following:
> >
> > I see this problem has been discussed before on the mailing list, and
> > the solution was to replace "template" files with older versions.
> > Unfortunately, I don't seem to have any template files in my
> > configuration (I can't locate any). My configuration works just fine
> > with MySQL.
> >
> > Thanks for any help.
> >
> > -Jon
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> * * * * * * D I S C L A I M E R * * * * * * *
>
> This message is confidential and intended for the named addressee(s)
only.
> If you are not the intended recipient, please contact the sender by
E-Mail
> return and then delete this message from your system. You should not copy
> or use it or disclose its contents to any other person.
>
> If any part of this message is illegible or if you suspect that the
message
> may have been intercepted or amended, please contact the sender.
> Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
> accuracy or completeness of this message without further investigation.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
