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 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.(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 All,
ASAIK these two license files are to be used as follows:
*db2jcc_license_cu.jar*
for Linux, UNIX and Windows servers (I guess all on Intel). This is the
standard license.
*db2jcc_license_cisuz.jar*
for z/OS and iSeries in addition to the other (standard) license.
Cheers!
Hernan
Matt Hogstrom wrote:
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:
TradeDataSource
tranql/tranql-connector-db2-xa/1.0/rar
http://geronimo.apache.org/xml/ns/j2ee/connector";
configId="TradeDataSource"
parentId="org/apache/geronimo/Server">
com.ibm.db2/db2jcc/10.1/jar
com.ibm.db2/db2jcc_license_cisuz/10.1/jar
com.ibm.db2/db2jcc_license_cu/10.1/jar
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.(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
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.(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
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:
TradeDataSource
tranql/tranql-connector-db2-xa/1.0/rar
http://geronimo.apache.org/xml/ns/j2ee/connector";
configId="TradeDataSource"
parentId="org/apache/geronimo/Server">
com.ibm.db2/db2jcc/10.1/jar
com.ibm.db2/db2jcc_license_cisuz/10.1/jar
com.ibm.db2/db2jcc_license_cu/10.1/jar
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.(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.(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
Need help with db2jcc_license_cu jar file deployment
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.(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
