geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul McMahan <paulmcma...@gmail.com>
Subject Re: Need help with db2jcc_license_cu jar file deployment
Date Wed, 01 Feb 2006 21:38:55 GMT
FYI --- I attached a patch for the 1.0.1 branch to GERONIMO-1524 that will
allow multiple jars to be selected for a database pool.  This will allow the
console to create database pools for DB2 using the extra license jar.

Best wishes,
Paul

On 1/31/06, Hernan Cunico <hcunico@gmail.com> wrote:
>
> 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:
> >
> > 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