You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Marcial Atienzar Navarro <ma...@teleco.upv.es> on 2002/12/17 19:54:07 UTC
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Error in tdk 2.2.01 when I do ant init
Posted by Rodney Schneider <ro...@actf.com.au>.
On Wed, 18 Dec 2002 05:54, you wrote:
> 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?
I don't know anything about SapDB, but if you look at you errors they
are either "Missing identifier" which probably means that the SQL being
executed is invalid or "Unknown table name" which probably means that
the tables have not been created. Did you manually create the tables
in your database or are you relying on the "create-db" target to do
this for you?
-- Rodney
> 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
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Error in tdk 2.2.01 when I do ant init
Posted by Marcial Atienzar Navarro <ma...@teleco.upv.es>.
Hello,
Yes, the errors are missing identifiers. I'm relying on the "create-db" target
to do this. There are some query that the turbine can't process to sapdb, these
queries are the ones that have a UNIQUE field on its schema. SAPDB seems that
doesn't work with UNIQUE fields, instence of this it must be used INDEX fields,
i think, but doing this there ara also queries that continue not working.
I'm only doing ant init on the example aplication of turbine (newapp). I think
that it's a bug of torque with SAPDB, it seems to to work fine.
A lot of thanks,
Marcial Atienzar
Missatge citat per: Rodney Schneider <ro...@actf.com.au>:
> On Wed, 18 Dec 2002 05:54, you wrote:
> > 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?
>
> I don't know anything about SapDB, but if you look at you errors they
> are either "Missing identifier" which probably means that the SQL being
>
> executed is invalid or "Unknown table name" which probably means that
> the tables have not been created. Did you manually create the tables
> in your database or are you relying on the "create-db" target to do
> this for you?
>
> -- Rodney
>
>
> > 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
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>