Thomas,
I put in the templates from 3.1, and now it's putting an extra comma
on the end of the fields for each table. It's unable to execute the
CREATE statements. I get these errors:
[torque-sql-exec] [ERROR] Failed to execute: CREATE TABLE
gd_sales_unit_rcs ( busseg VARCHAR2 (6), sales_unit VARCHAR2 (6), )
[torque-sql-exec] [ERROR] java.sql.SQLException: ORA-00904: :
invalid identifier
I had this problem before with 3.1 and MySQL. The solution was to
use 3.1.1. :-o What should I do?
-Jon
On Jun 14, 2005, at 3:35 AM, Thomas Fischer wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
