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]

Reply via email to