db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon August <...@internection.com>
Subject maven torque:insert-sql produces errors with oracle
Date Mon, 13 Jun 2005 21:03:29 GMT
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


Mime
View raw message