Re: Need help with db2jcc_license_cu jar file deployment
For now, your best bet is to create the pool in the console but don't
test it, and then use the Show Plan option. Then save the plan to a
file, and copy the dependency element that refers to the JDBC driver
JAR and point the copies to the additionaly driver JAR(s) you need.
Then you can deploy that plan using the command-line deployment tool
like this:
java -jar bin/deployer.jar
repository/tranql/rars/tranql-connector-1.1.rar my-plan.xml
Thanks,
Aaron
On 1/31/06, [EMAIL PROTECTED]
[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]) 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
Re: Need help with db2jcc_license_cu jar file deployment
Hi Prakash,
I'm working on a document for configuring DB2 in Geronimo. I'll post the link here in the dev list
once I have it finished (probably by tomorrow)
Cheers!
Hernan
[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
Re: Need help with db2jcc_license_cu jar file deployment
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 users2063 2006-01-11 09:17
db2jcc_license_cisuz-10.1.jar
-rwxr-xr-x 1 hogstrom users1013 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
connectorTradeDataSource/connector
external-pathtranql/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
uricom.ibm.db2/db2jcc/10.1/jar/uri
/dependency
dependency
uricom.ibm.db2/db2jcc_license_cisuz/10.1/jar/uri
/dependency
dependency
uricom.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
Documentation update - was [ Need help with db2jcc_license_cu jar file deployment]
Hi All,
here is an article on how to configure DB2 (or any other DB needing more than
one jar file)
http://opensource2.atlassian.com/confluence/oss/display/GERONIMO/Configuring+DB2+Datasource
Cheers!
Hernan
[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
