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