geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Hogstrom <m...@hogstrom.org>
Subject Re: Need help with db2jcc_license_cu jar file deployment
Date Tue, 31 Jan 2006 21:50:17 GMT
Prakash,

Here is the setup I am currently using.

I added the DB2 jars to my repository as follows:

hogstrom@hurricaine:~/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.

Prakash.Sajja@tdcj.state.tx.us 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 (yskim@symcor.com 
> <mailto:yskim@symcor.com>) 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
>  

Mime
View raw message