--- Milisic Aleksandar <[EMAIL PROTECTED]>
wrote:
> Thanks, Armin.
>
> That was the problem (i.e. old ojb in my classpath).
>
>
Unfortunately, I have run into a different problem. I
am so bewildered by it that I started another small
project in one of the ojb-blank environments for
ojb1.04 to test this out and make sure it has nothing
to do with my environment.
It seems that the generated SQL has syntax errors in
it, I just can't figure out what is causing it. The
differences I see compared to version 1.03 is that in
build.xml dtdUrl is different as well as the torque
version. The one I am using with ojb1.04 is
torque-gen-3.1.1.jar.
Anyway, the list of jar's I am using is basically the
one in ojb-blank for ojb1.04. The list is:
antlr-2.7.5.jar
commons-lang-2.1.jar
commons-beanutils-1.7.0.jar
commons-betwixt-0.8-dev.jar
commons-collections-3.1.jar
commons-dbcp-1.2.1.jar
commons-digester-1.7.jar
commons-logging-1.0.4.jar
commons-pool-1.2.jar
commons-transaction-1.1.jar
db-ojb-1.0.4.jar
hsqldb.jar
log4j-1.2.8.jar
torque-gen-3.1.1.jar
velocity-1.3.1.jar
xdoclet-1.2.3.jar
xdoclet-ojb-module-1.2.3.jar
xjavadoc-1.1.jar
The few other differences I noticed is that in 1.04 in
build-torque.xml, in the 'insert-sql' target there is
a 'torque.delimiter' value, could it be causing the
problem and what does it mean?
Also, in build-torque.xml in the 'torque.lib.dir'
description, there is mention of
commons-lang-1.0.1.jar even though the new version of
commons-lang-2.1.jar is the one that is supposed to be
used?
Anyway, those are just the things that I have been
looking at first in order to solve my problem, but I
haven't managed to do that. Here is the output I get
for the generated sql:
*************************************************
ant setup-db
Buildfile: build.xml
compile:
xdoclet:
[ojbdoclet] [WARN] findModules - There is an entry on
XDoclets classpath that doesn't exist: {0}. Ignoring
it
[ojbdoclet] [INFO] start - Running <ojbrepository/>
[ojbdoclet] [INFO] start - Running <torqueschema/>
setup-db:
check-use-classpath:
check-run-only-on-schema-change:
sql-check:
sql:
[echo]
+------------------------------------------+
[echo] |
|
[echo] | Generating SQL for YOUR Torque project!
|
[echo] |
|
[echo]
+------------------------------------------+
sql-classpath:
[echo] loading templates from classpath
[torque-sql] Using contextProperties file:
/home/ami01/download/ojb1.04/ojb-blank/build.properties
[torque-sql] Using classpath
[torque-sql] Generating to file
/home/ami01/download/ojb1.04/ojb-blank/build/database/report.tpacData.sql.generation
[torque-sql] [INFO] XmlToAppData - Parsing file:
'ojbcore-schema.xml'
[torque-sql] [INFO] DTDResolver - Resolver: used
database.dtd from
'org.apache.torque.engine.database.transform' package
[torque-sql] [INFO] XmlToAppData - Parsing file:
'project-schema.xml'
[torque-sql] [INFO] DTDResolver - Resolver: used
database.dtd from
'org.apache.torque.engine.database.transform' package
sql-template:
create-db-check:
create-db:
[torque-data-model] Using classpath
[torque-data-model] Generating to file
/home/ami01/download/ojb1.04/ojb-blank/build/database/create-db.sql
[torque-data-model] [INFO] XmlToAppData - Parsing
file: 'ojbcore-schema.xml'
[torque-data-model] [INFO] DTDResolver - Resolver:
used database.dtd from
'org.apache.torque.engine.database.transform' package
[torque-data-model] [INFO] XmlToAppData - Parsing
file: 'project-schema.xml'
[torque-data-model] [INFO] DTDResolver - Resolver:
used database.dtd from
'org.apache.torque.engine.database.transform' package
shutdown-check:
append-shutdown-sql:
[echo]
[echo] Executing the create-db.sql script
...
[echo]
[sql] Executing file:
/home/ami01/download/ojb1.04/ojb-blank/build/database/create-db.sql
[sql] 0 of 0 SQL statements executed
successfully
insert-sql:
shutdown-check:
add-shutdown-sql-file:
[torque-sql-exec] Our new url ->
jdbc:oracle:thin:@cetus:1521:alex
[torque-sql-exec] Executing file:
/home/ami01/download/ojb1.04/ojb-blank/build/database/project-schema.sql
[torque-sql-exec] Failed to execute: DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Leg CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE Leg ( mLegId NUMBER NOT
NULL, mTripNumber VARCHAR2 (254), mModelId NUMBER ) /
ALTER TABLE Leg ADD CONSTRAINT Leg_PK PRIMARY KEY
(mLegId) / DECLARE TABLE_DOES_NOT_EXIST EXCEPTION;
PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942);
BEGIN EXECUTE IMMEDIATE 'DROP TABLE Model CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE Model ( mName VARCHAR2
(254), mModelId NUMBER NOT NULL, mParentModelId
NUMBER, mModelKey VARCHAR2 (254), mContainerId NUMBER
) / ALTER TABLE Model ADD CONSTRAINT Model_PK PRIMARY
KEY (mModelId) / DECLARE TABLE_DOES_NOT_EXIST
EXCEPTION; PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST,
-942); BEGIN EXECUTE IMMEDIATE 'DROP TABLE
ModelContainer CASCADE CONSTRAINTS'; EXCEPTION WHEN
TABLE_DOES_NOT_EXIST THEN NULL; END; / CREATE TABLE
ModelContainer ( mId NUMBER NOT NULL, mName VARCHAR2
(254), mDescription VARCHAR2 (254) ) / ALTER TABLE
ModelContainer ADDCONSTRAINT ModelContainer_PK PRIMARY
KEY (mId) / ALTER TABLE Leg ADD CONSTRAINT Leg_FK_1
FOREIGN KEY (mModelId) REFERENCES Model (mModelId) /
ALTER TABLE Model ADD CONSTRAINT Model_FK_1 FOREIGN
KEY (mContainerId) REFERENCES ModelContainer (mId) /
[torque-sql-exec] java.sql.SQLException: ORA-06550:
line 1, column 206:
[torque-sql-exec] PLS-00103: Encountered the symbol
"/"
[torque-sql-exec] Executing file:
/home/ami01/download/ojb1.04/ojb-blank/build/database/ojbcore-schema.sql
[torque-sql-exec] Failed to execute: DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_HL_SEQ CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_HL_SEQ ( TABLENAME
VARCHAR2 (250) NOT NULL, MAX_KEY NUMBER (20, 0),
GRAB_SIZE NUMBER, VERSION NUMBER ) / ALTER TABLE
OJB_HL_SEQ ADD CONSTRAINT OJB_HL_SEQ_PK PRIMARY KEY
(TABLENAME) / DECLARE TABLE_DOES_NOT_EXIST EXCEPTION;
PRAGMA EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942);
BEGIN EXECUTE IMMEDIATE 'DROP TABLE OJB_NRM CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_NRM ( NAME VARCHAR2
(250) NOT NULL, OID_ LONG RAW ) / ALTER TABLE OJB_NRM
ADD CONSTRAINT OJB_NRM_PK PRIMARY KEY (NAME) / DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_DLIST CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_DLIST ( ID NUMBER NOT
NULL, SIZE_ NUMBER ) / ALTER TABLE OJB_DLIST ADD
CONSTRAINT OJB_DLIST_PK PRIMARY KEY (ID) / DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_DLIST_ENTRIES
CASCADE CONSTRAINTS'; EXCEPTION WHEN
TABLE_DOES_NOT_EXIST THEN NULL; END; / CREATE TABLE
OJB_DLIST_ENTRIES ( ID NUMBER NOT NULL, DLIST_ID
NUMBER NOT NULL, POSITION_ NUMBER, OID_ LONG RAW ) /
ALTER TABLE OJB_DLIST_ENTRIES ADD CONSTRAINT
OJB_DLIST_ENTRIES_PK PRIMARY KEY (ID) / DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_DSET CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_DSET ( ID NUMBER NOT
NULL, SIZE_ NUMBER ) / ALTER TABLE OJB_DSET ADD
CONSTRAINT OJB_DSET_PK PRIMARY KEY(ID) / DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_DSET_ENTRIES CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_DSET_ENTRIES ( ID NUMBER
NOT NULL, DLIST_ID NUMBER NOT NULL, POSITION_ NUMBER,
OID_ LONG RAW ) / ALTER TABLE OJB_DSET_ENTRIES ADD
CONSTRAINT OJB_DSET_ENTRIES_PK PRIMARY KEY (ID) /
DECLARE TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_DMAP CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_DMAP ( ID NUMBER NOT
NULL, SIZE_ NUMBER ) / ALTER TABLE OJB_DMAP ADD
CONSTRAINT OJB_DMAP_PK PRIMARY KEY (ID) / DECLARE
TABLE_DOES_NOT_EXIST EXCEPTION; PRAGMA
EXCEPTION_INIT(TABLE_DOES_NOT_EXIST, -942); BEGIN
EXECUTE IMMEDIATE 'DROP TABLE OJB_DMAP_ENTRIES CASCADE
CONSTRAINTS'; EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
NULL; END; / CREATE TABLE OJB_DMAP_ENTRIES ( ID NUMBER
NOT NULL, DMAP_ID NUMBER NOT NULL, KEY_OID LONG RAW,
VALUE_OID LONG RAW ) / ALTER TABLE OJB_DMAP_ENTRIES
ADD CONSTRAINT OJB_DMAP_ENTRIES_PK PRIMARY KEY (ID) /
[torque-sql-exec] java.sql.SQLException: ORA-06550:
line 1, column 213:
[torque-sql-exec] PLS-00103: Encountered the symbol
"/"
[torque-sql-exec] 0 of 2 SQL statements executed
successfully
***************************************************
I hope somebody has an answer to this one because it's
driving me crazy, especially since I can't see anyone
else complaining about it.
Thank you.
____________________________________________________
Do you Yahoo!?
Stay in touch via Yahoo! Messenger with all your contacts on your 3 Mobile.
http://au.mobile.yahoo.com/mweb/3-mobile.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
