geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aaron Mulder <ammul...@alumni.princeton.edu>
Subject Re: Need help with db2jcc_license_cu jar file deployment
Date Thu, 02 Feb 2006 13:56:33 GMT
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, Prakash.Sajja@tdcj.state.tx.us
<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) 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