Hi there,
i tried to build the newapp-application on a DB2 Database.
I have 2 problems:
first) some generated sql-statements are failing
second) after the execution of the first sql-script, ant stops with the following
exception:
java.lang.UnsatisfiedLinkError: Native Library G:\db2\bin\db2jdbc.dll already loaded
in another classloader
Now, the first problem could be because i use a old version of DB2 (6.1) - i'm right
now downloading a new trial version,
though maybe some user here had the same problem(s) and a solution(s).
I got tdk running for postgresql, so i'm fairly sure that i did configure it right.
here the last output of the ant init:
turbine-insert-sql:
insert-sql-file:
[sql] Executing file:
G:\cvs\tdk\webapps\newapp\WEB-INF\src\sql\turbine-schema.sql
[sql] Failed to execute: ALTER TABLE TURBINE_PERMISSION ADD CONSTRAINT
TURBINE_PERMISSION_PK PRIMARY KEY (PERMISSION_ID)
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N
The name "TURBINE_PERMISSION_PK" is too long. The maximum length is "18".
SQLSTATE=42622
[sql] Failed to execute: ALTER TABLE TURBINE_ROLE_PERMISSION ADD CONSTRAINT
TURBINE_ROLE_PERMISSION_PK PRIMARY KEY (ROLE_ID,PERMISSION_ID)
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N
The name "TURBINE_ROLE_PERMISSION_PK" is too long. The maximum length is "18".
SQLSTATE=42622
[sql] Failed to execute: ALTER TABLE TURBINE_ROLE_PERMISSION ADD CONSTRAINT
TURBINE_ROLE_PERMISSION_FK_1 FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID)
USING INDEX
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected token "USING INDEX" was found following "RBINE_ROLE (ROLE_ID)".
Expected tokens may include: "<space>". SQLSTATE=42601
[sql] Failed to execute: ALTER TABLE TURBINE_ROLE_PERMISSION ADD CONSTRAINT
TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION
(PERMISSION_ID) USING INDEX
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected token "USING INDEX" was found following "SION (PERMISSION_ID)".
Expected tokens may include: "<space>". SQLSTATE=42601
[sql] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE ADD CONSTRAINT
TURBINE_USER_GROUP_ROLE_PK PRIMARY KEY (USER_ID,GROUP_ID,ROLE_ID)
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The
name "TURBINE_USER_GROUP_ROLE_PK" is too long. The maximum length is "18".
SQLSTATE=42622
[sql] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE ADD CONSTRAINT
TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID)
USING INDEX
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected token "USING INDEX" was found following "RBINE_USER (USER_ID)".
Expected tokens may include: "<space>". SQLSTATE=42601
[sql] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE ADD CONSTRAINT
TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP
(GROUP_ID) USING INDEX
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected token "USING INDEX" was found following "INE_GROUP (GROUP_ID)".
Expected tokens may include: "<space>". SQLSTATE=42601
[sql] Failed to execute: ALTER TABLE TURBINE_USER_GROUP_ROLE ADD CONSTRAINT
TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID)
USING INDEX
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected token "USING INDEX" was found following "RBINE_ROLE (ROLE_ID)".
Expected tokens may include: "<space>". SQLSTATE=42601
[sql] Failed to execute: ALTER TABLE TURBINE_SCHEDULED_JOB ADD CONSTRAINT
TURBINE_SCHEDULED_JOB_PK PRIMARY KEY (JOB_ID)
[sql] COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0107N The
name "TURBINE_SCHEDULED_JOB_PK" is too long. The maximum length is "18".
SQLSTATE=42622
[sql] 17 of 26 SQL statements executed successfully
insert-sql-file:
BUILD SUCCESSFUL
Total time: 19 seconds
java.lang.UnsatisfiedLinkError: Native Library G:\db2\bin\db2jdbc.dll already loaded
in another classloader
