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]>
