db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: maven torque:insert-sql produces errors with oracle
Date Tue, 14 Jun 2005 07:35:37 GMT




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)" <Erik.Dressler@Dresdner-Bank.lu> 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:jon@internection.com]
> > 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: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
>
> *  *  *  *  *  *  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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
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