Prakash,
Here is the setup I am currently using.
I added the DB2 jars to my repository as follows:
[EMAIL PROTECTED]:~/geronimo-1.0/repository/com.ibm.db2/jars> ls -al
total 1233
drwxr-xr-x 3 hogstrom users 200 2006-01-31 14:02 .
drwxr-xr-x 3 hogstrom users 72 2006-01-11 09:15 ..
-rw-r--r-- 1 hogstrom users 1249462 2006-01-11 09:16 db2jcc-10.1.jar
-rwxr-xr-x 1 hogstrom users 2063 2006-01-11 09:17
db2jcc_license_cisuz-10.1.jar
-rwxr-xr-x 1 hogstrom users 1013 2006-01-11 09:17 db2jcc_license_cu-10.1.jar
Ignore the version, I think I was using the Derby version number for some reason
but these are from a DB2 UDB V8 distro.
I added the following lines to my application plan. This is for the DataSource
definition:
<ext-module>
<connector>TradeDataSource</connector>
<external-path>tranql/tranql-connector-db2-xa/1.0/rar</external-path>
<connector
xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector";
configId="TradeDataSource"
parentId="org/apache/geronimo/Server">
<dependency>
<uri>com.ibm.db2/db2jcc/10.1/jar</uri>
</dependency>
<dependency>
<uri>com.ibm.db2/db2jcc_license_cisuz/10.1/jar</uri>
</dependency>
<dependency>
<uri>com.ibm.db2/db2jcc_license_cu/10.1/jar</uri>
</dependency>
I see you do not refer to the cusiz license (and I don't know what it is) :)
Try this out.
[EMAIL PROTECTED] wrote:
Hello,
I am very new to Geronimo, have installed Geronimo-Tomcat-J2EE-1.0 just last
week on my Window-XP to evaluate it. I have DB2 UDB Workgroup server 8.2 running
on another Windows server within my LAN and I am trying to add a database pool
for this DB2 using Geronimo Web Console.
I could successfully add the two jar files db2jcc.jar and db2jcc_license_cu.jar
to the Geronimo repository and they are now under
...\geronimo-1.0\repository\db2\jars but renamed as db2jcc-8.2.jar and
db2jcc_license_cu-8.2.jar respectively since I specified their version as 8.2.
They are listed as db2/db2jcc/8.2/jar and db2/db2jcc_license_cu/8.2/jar
respectively under the Current Repository Entries.
While adding the new database pool, I can successfully step through until the
"Test Connection" which fails trying to find the appropriate license file
db2jcc_license_cu.jar. Below is the error message:
==========================================
com.ibm.db2.jcc.b.SqlException: The version of the IBM Universal JDBC driver in
use is not licensed for connectivity to DB2 for Unix/Windows databases. To
connect to this DB2 server, please obtain a licensed copy of the IBM DB2
Universal Driver for JDBC and SQLJ. An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application classpath. Connectivity to DB2 for Unix/Windows databases is
enabled by any of the following license files: { db2jcc_license_cu.jar,
db2jcc_license_cisuz.jar }
at com.ibm.db2.jcc.b.o.db(o.java:3103)
at com.ibm.db2.jcc.b.o.cb(o.java:3049)
at com.ibm.db2.jcc.a.b.cb(b.java:629)
at com.ibm.db2.jcc.a.b.<init>(b.java:306)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.attemptConnect(DatabasePoolPortlet.java:797)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:321)
...
...
...
===========================================
The DB2 license file name is expected to be db2jcc_license_cu.jar, but the Web
Console renames it to db2jcc_license_cu-8.2.jar due to its jar file naming rules.
I have seen a posting by Mr. Young Skim ([EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>) on 01/12/2006 seeking help on the same problem and I
have tried one of the solutions posted by Mr. Matt Hogstrom i.e. add
dependency to these jar files to the application's deployment plan. It did not
work, may be because I am not sure exactly to which xml file, I should add this.
Please help me!
Thanks a lot!
Prakash
