Hello,
In the id-table-schema.xml I have this:
<database name="inmo">
<table name="ID_TABLE" idMethod="idbroker">
<column name="ID_TABLE_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="TABLE_NAME" required="true" size="255" type="VARCHAR"/>
<column name="NEXT_ID" type="INTEGER"/>
<column name="QUANTITY" type="INTEGER"/>
<unique>
<unique-column name="TABLE_NAME"/>
</unique>
</table>
</database>
And I think that I have to change the unique element by an index element. Doing
this I have less errors on the sql. Ant init make a build ok, but there are some
queries that doesn't execute.
I'm working with jdk 1.4.1. May be it the problem, or the problem id in Torque?
EN> Hello, I htink you have have to change an entry in the id-table-schema.xml:
EN> "<database>" to "<database name=@YOUR_DATABASE@>"
EN> Hope this helps!
EN> MfG, Norman Esseling
EN> -----Urspr�ngliche Nachricht-----
EN> Von: Marcial Atienzar Navarro [mailto:[EMAIL PROTECTED]]
EN> Gesendet am: Dienstag, 17. Dezember 2002 19:54
EN> An: [EMAIL PROTECTED]
EN> Betreff: Error in tdk 2.2.01 when I do ant init
EN> Hello,
EN> I have this database settings:
EN> database.name = inmo
EN> database = sapdb
EN> createDatabaseUrl = jdbc:sapdb://localhost/inmo
EN> buildDatabaseUrl = jdbc:sapdb://localhost/inmo
EN> databaseUrl = jdbc:sapdb://localhost/inmo
EN> databaseDriver = com.sap.dbtech.jdbc.DriverSapDB
EN> databaseUser = xxx
EN> databasePassword = xxx
EN> databaseHost = localhost
EN> When I do ant init I have this errors. To solve some of them I have to edit
EN> the
EN> .schema to change the unique identifier by index identifier. Have I doind
EN> something wrong? or is it a bug?
EN> A lot of thanks,
EN> Marcial Atienzar
EN> Error:
EN> [torque-sql-exec] Executing file:
EN> C:\tdk\webapps\inmo\WEB-INF\src\sql\id-table-s
EN> chema.sql
EN> [torque-sql-exec] Failed to execute: CREATE TABLE ID_TABLE ( ID_TABLE_ID
EN> INTEGER
EN> NOT NULL, TABLE_NAME VARCHAR (255) NOT NULL, NEXT_ID INTEGER, QUANTITY
EN> INTEGER,
EN> UNIQUE (TABLE_NAME) )
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5006]
EN> (at
EN> 132): Missing identifier
EN> [torque-sql-exec] Failed to execute: ALTER TABLE ID_TABLE ADD PRIMARY KEY
EN> (ID_TA
EN> BLE_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Executing file:
EN> C:\tdk\webapps\inmo\WEB-INF\src\sql\turbine-sc
EN> hema.sql
EN> [torque-sql-exec] Failed to execute: CREATE TABLE TURBINE_PERMISSION (
EN> PERMISSIO
EN> N_ID INTEGER NOT NULL, PERMISSION_NAME VARCHAR (99) NOT NULL, OBJECTDATA
EN> LONG BY
EN> TE, UNIQUE (PERMISSION_NAME) )
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5006]
EN> (at
EN> 135): Missing identifier
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_PERMISSION ADD
EN> PRIMARY
EN> KEY (PERMISSION_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_PERMISSION
EN> [torque-sql-exec] Failed to execute: CREATE TABLE TURBINE_ROLE ( ROLE_ID
EN> INTEGER
EN> NOT NULL, ROLE_NAME VARCHAR (99) NOT NULL, OBJECTDATA LONG BYTE, UNIQUE
EN> (ROLE_N
EN> AME) )
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5006]
EN> (at
EN> 117): Missing identifier
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_ROLE ADD PRIMARY
EN> KEY (R
EN> OLE_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_ROLE
EN> [torque-sql-exec] Failed to execute: CREATE TABLE TURBINE_GROUP ( GROUP_ID
EN> INTEG
EN> ER NOT NULL, GROUP_NAME VARCHAR (99) NOT NULL, OBJECTDATA LONG BYTE, UNIQUE
EN> (GRO
EN> UP_NAME) )
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5006]
EN> (at
EN> 120): Missing identifier
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_GROUP ADD PRIMARY
EN> KEY (
EN> GROUP_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_GROUP
EN> [torque-sql-exec] Failed to execute: CREATE TABLE TURBINE_USER ( USER_ID
EN> INTEGER
EN> NOT NULL, LOGIN_NAME VARCHAR (32) NOT NULL, PASSWORD_VALUE VARCHAR (32) NOT
EN> NUL
EN> L, FIRST_NAME VARCHAR (99) NOT NULL, LAST_NAME VARCHAR (99) NOT NULL, EMAIL
EN> VARC
EN> HAR (99), CONFIRM_VALUE VARCHAR (99), MODIFIED TIMESTAMP, CREATED TIMESTAMP,
EN> LAS
EN> T_LOGIN TIMESTAMP, OBJECTDATA LONG BYTE, UNIQUE (LOGIN_NAME) )
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5006]
EN> (at
EN> 332): Missing identifier
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_USER ADD PRIMARY
EN> KEY (U
EN> SER_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_USER
EN> [torque-sql-exec] Failed to execute: drop table TURBINE_SCHEDULED_JOB
EN> cascade
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 12): Unknown table name:TURBINE_SCHEDULED_JOB
EN> [torque-sql-exec] Failed to execute: CREATE TABLE TURBINE_SCHEDULED_JOB (
EN> JOB_ID
EN> INTEGER NOT NULL, SECOND INTEGER default -1 NOT NULL, MINUTE INTEGER
EN> default -1
EN> NOT NULL, HOUR INTEGER default -1 NOT NULL, WEEK_DAY INTEGER default -1 NOT
EN> NUL
EN> L, DAY_OF_MONTH INTEGER default -1 NOT NULL, TASK VARCHAR (99) NOT NULL,
EN> EMAIL V
EN> ARCHAR (99), PROPERTY LONG BYTE )
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-7006]
EN> (at
EN> 63): Reserved identifier not allowed
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_SCHEDULED_JOB ADD
EN> PRIMA
EN> RY KEY (JOB_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_SCHEDULED_JOB
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_ROLE_PERMISSION
EN> FOREIGN
EN> KEY TURBINE_ROLE_PERMISSION_FK_1 (ROLE_ID) REFERENCES TURBINE_ROLE
EN> (ROLE_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 99): Unknown table name:TURBINE_ROLE
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_ROLE_PERMISSION
EN> FOREIGN
EN> KEY TURBINE_ROLE_PERMISSION_FK_2 (PERMISSION_ID) REFERENCES
EN> TURBINE_PERMISSION
EN> (PERMISSION_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 105): Unknown table name:TURBINE_PERMISSION
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE
EN> FOREIGN
EN> KEY TURBINE_USER_GROUP_ROLE_FK_1 (USER_ID) REFERENCES TURBINE_USER
EN> (USER_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 99): Unknown table name:TURBINE_USER
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE
EN> FOREIGN
EN> KEY TURBINE_USER_GROUP_ROLE_FK_2 (GROUP_ID) REFERENCES TURBINE_GROUP
EN> (GROUP_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 100): Unknown table name:TURBINE_GROUP
EN> [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE
EN> FOREIGN
EN> KEY TURBINE_USER_GROUP_ROLE_FK_3 (ROLE_ID) REFERENCES TURBINE_ROLE
EN> (ROLE_ID)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 99): Unknown table name:TURBINE_ROLE
EN> [torque-sql-exec] Executing file:
EN> C:\tdk\webapps\inmo\WEB-INF\src\sql\inmo-schem
EN> a.sql
EN> [torque-sql-exec] Executing file:
EN> C:\tdk\webapps\inmo\WEB-INF\src\sql\turbine-sc
EN> hema-idtable-init.sql
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1101, 'TURBINE_PERMISSION', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1102, 'TURBINE_ROLE', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1103, 'TURBINE_GROUP', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1104, 'TURBINE_ROLE_PERMISSION', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1105, 'TURBINE_USER', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1106, 'TURBINE_USER_GROUP_ROLE', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (1107, 'TURBINE_SCHEDULED_JOB', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] Executing file:
EN> C:\tdk\webapps\inmo\WEB-INF\src\sql\turbine-se
EN> curity.sql
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_GROUP
EN> (GROUP_ID,GROUP_N
EN> AME) VALUES (1,'global')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_GROUP
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_PERMISSION
EN> (PERMISSION_
EN> ID,PERMISSION_NAME) VALUES (1,'admin_users')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_PERMISSION
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_PERMISSION
EN> (PERMISSION_
EN> ID,PERMISSION_NAME) VALUES (2,'homepage_access')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_PERMISSION
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_ROLE
EN> (ROLE_ID,ROLE_NAME
EN> ) VALUES (1,'turbine_root')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_ROLE
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_ROLE
EN> (ROLE_ID,ROLE_NAME
EN> ) VALUES (2,'Site Administrator')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_ROLE
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_USER
EN> (USER_ID,LOGIN_NAM
EN> E,PASSWORD_VALUE,FIRST_NAME,LAST_NAME) VALUES
EN> (1,'turbine','turbine','turbine','
EN> turbine')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_USER
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_USER
EN> (USER_ID,LOGIN_NAM
EN> E,PASSWORD_VALUE,FIRST_NAME,LAST_NAME) VALUES
EN> (2,'bbarker','user1','Bob','Barker
EN> ')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_USER
EN> [torque-sql-exec] Failed to execute: INSERT INTO TURBINE_USER
EN> (USER_ID,LOGIN_NAM
EN> E,PASSWORD_VALUE,FIRST_NAME,LAST_NAME) VALUES
EN> (3,'mhall','user2','Monty','Hall')
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:TURBINE_USER
EN> [torque-sql-exec] Executing file:
EN> C:\tdk\webapps\inmo\WEB-INF\src\sql\inmo-schem
EN> a-idtable-init.sql
EN> [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id,
EN> table_na
EN> me, next_id, quantity) VALUES (101, 'RDF', 1000, 10)
EN> [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004]
EN> (at
EN> 13): Unknown table name:ID_TABLE
EN> [torque-sql-exec] 17 of 51 SQL statements executed successfully
EN> update-tr-props:
EN> [copy] Copying 1 file to C:\tdk\webapps\inmo\WEB-INF\conf
EN> [copy] Copying 1 file to C:\tdk\webapps\inmo\WEB-INF\conf
EN> project-om:
EN> check-use-classpath:
EN> check-run-only-on-schema-change:
EN> om-check:
EN> om:
EN> [echo] +------------------------------------------+
EN> [echo] | |
EN> [echo] | Generating Peer-based Object Model for |
EN> [echo] | YOUR Torque project! Woo hoo! |
EN> [echo] | |
EN> [echo] +------------------------------------------+
EN> om-classpath:
EN> [torque-data-model] Using contextProperties file:
EN> C:\tdk\webapps\inmo\WEB-INF\bu
EN> ild\build.properties
EN> [torque-data-model] Using classpath
EN> [torque-data-model] Generating to file
EN> C:\tdk\webapps\inmo\WEB-INF\src\java\repo
EN> rt.inmo.om.generation
EN> [torque-data-model] Resolver: used database.dtd from
EN> org.apache.torque.engine.da
EN> tabase.transform package
EN> [torque-data-model] Resolver: used database.dtd from
EN> org.apache.torque.engine.da
EN> tabase.transform package
EN> om-template:
EN> setup:
EN> check-webinf-exists:
EN> setup-webinf:
EN> compile:
EN> [javac] Compiling 47 source files to C:\tdk\webapps\inmo\WEB-INF\classes
EN> copy-log4j-properties:
EN> [copy] Copying 1 file to C:\tdk\webapps\inmo\WEB-INF\classes
EN> BUILD SUCCESSFUL
EN> --
EN> To unsubscribe, e-mail:
EN> <mailto:[EMAIL PROTECTED]>
EN> For additional commands, e-mail:
EN> <mailto:[EMAIL PROTECTED]>
EN> --
EN> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
EN> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
