Page History

{scrollbar}

This article shows you how to configure a DB2 datasource in Apache Geronimo v1.0. Normally you would just use the Geronimo Administration Console and the creation pool wizard for this task but that method allows you to specify only ONE driver jar file. In the case of DB2 you would have multiple files, one for the driver and two additional files for the license.

...

These files are available in the <sqllib_home>\java directory. For additional information on the DB2 JDBC drivers and licenses visit the DB2 Information Center available at the following URL:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/t0010264.htm^{Image Removed}

In order to use these files in Geronimo you will need to rename (copy and rename) as described in the following table.

...

In order to use the console Apache Geronimo must be running. Access the Geronimo Administration Console by pointing your browser to the following URL:

http://localhost:8080/console^{Image Removed}

• Enter the system as the user and manager as the password and click Login.
• Click on Common Libs to access the Repository viewer portlet.
• Click on Browse and select the first file to install. In this case we will first install db2jcc-8.1.8.jar.
• A set of values will be proposed by default, set the Group: to com.ibm, leave the rest by default and click Install.
• Repeate the previous two steps for db2jcc_license_cisuz-8.1.8.jar and db2jcc_license_cisuz-8.1.8.jar

...

deploy --user system --password manager deploy db2-plan.xml ..\repository\tranql\tranql-connector\1.12\tranql-connector-1.12.rar

You should receive the following message:

E:\geronimo-1.1\bin>deploy --user system --password manager deploy db2-plan.xml ..\repository\tranql\tranql-connector\1.12\tranql-connector-1.12.rar
Using GERONIMO_BASE:   E:\geronimo-1.1
Using GERONIMO_HOME:   E:\geronimo-1.1
Using GERONIMO_TMPDIR: E:\geronimo-1.1\var\temp
Using JRE_HOME:        C:\j2sdk1.4.2_09
    Deployed console.dbpool/DB2_ds/1.0/rar

...