i solved this myself ^^
i put the jdbc-driver of DB2 (as a jar) in the ant/lib directory,
with that the JNI-Call is done on the lib as shared and the
error does not occur anymore.
----- Original Message -----
From: "Christine Keim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 1:26 PM
Subject: DB2 newapp building errors
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
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
