Page History

...

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/v8v9/index.jsp?topic=/com.ibm.db2.udb.doc/ad/t0010264.htm^{Image Modified}

In order to use these files in Geronimo, rename (copy and rename) the files according to the following table.

Original name	Renamed
db2jcc.jar	db2jcc-89.1.85.jar
db2jcc_license_cu.jar	db2jcc_license_cu-89.1.85.jar
db2jcc_license_cisuz.jar	db2jcc_license_cisuz-89.1.85.jar

This means that for this particular case DB2 v8.1.8.806 v9.5 was used.

At this point you are ready to add those files to the Geronimo repository in two ways. You can either use any graphical or command line tool to copy the files and create the necessary directories, or you use the Geronimo Administration Console and add the driver and licenses to the common libraries. See the following details.

...

Create the following directory structures under the <geronimo_home>\repository directory and copy the appropriate files to the respective directories.

com/ibm/db2/db2jcc/89.1.85
and copy the db2jcc-89.15.8.jar into that directory.

com/ibm/db2/db2jcc_license_cisuz/89.1.85
and copy the db2jcc_license_cisuz-89.15.8.jar into that directory.

com/ibm/db2/db2jcc_license_cu/89.1.85
and copy the db2jcc_license_cisuz-89.15.8.jar into that directory.

Using the Geronimo Administration Console

...

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-89.15.8.jar.
A set of values will be proposed by default, set the Group: to com.ibm.db2, leave the rest by default and click Install.
Repeat the previous two steps for db2jcc_license_cisuz-89.1.85.jar and db2jcc_license_cisuz-89.1.85.jar

With the drivers and license files installed, you can now create a new database connection pool.

...

In Step 2, leave the JDBC Driver Class: field by default (com.ibm.db2.jcc.DB2Driver). If you click the Driver JAR: pull-down menu you should now see the three com.ibm/db2... jars you copied in the repository. Since Geronimo v1.1 only allow you to select ONE jar file from this menu select the first jar on the list, com.ibm/db2jcc/89.1.85/jar which is the driver itself. You will add manually the license jars in the next steps.

...

Code Block

	xml
	xml
borderStyle	solid
title	db2-plan.xml deployment plan

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
    <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
        <dep:moduleId>
            <dep:groupId>console.dbpool</dep:groupId>
            <dep:artifactId>DB2_ds</dep:artifactId>
            <dep:version>1.0</dep:version>
            <dep:type>rar</dep:type>
        </dep:moduleId>
        <dep:dependencies>
            <dep:dependency>
                <dep:groupId>com.ibm.db2</dep:groupId>
                <dep:artifactId>db2jcc</dep:artifactId>
                <dep:version>8version>9.1.8<5</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
            <dep:dependency>
                <dep:groupId>com.ibm.db2</dep:groupId>
                <dep:artifactId>db2jcc_license_cisuz</dep:artifactId>
                <dep:version>8version>9.1.8<5</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
            <dep:dependency>
                <dep:groupId>com.ibm.db2</dep:groupId>
                <dep:artifactId>db2jcc_license_cu</dep:artifactId>
                <dep:version>8version>9.1.8<5</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
        </dep:dependencies>
    </dep:environment>
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>DB2_ds</name>
                    <config-property-setting name="Password">db2admin</config-property-setting>
                    <config-property-setting name="Driver">com.ibm.db2.jcc.DB2Driver</config-property-setting>
                    <config-property-setting name="UserName">db2admin</config-property-setting>
                    <config-property-setting name="ConnectionURL">jdbc:db2://localhost:50000/SAMPLE</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>
</connector>

...

deploy --user system --password manager deploy <dep_plan_home>\db2-plan.xml ..\repository\org\tranql\tranql-connector-radb2-xa\1.3\tranql-connector-db2-raxa-1.3.rar

You will receive the following message:

No Format

bgColor	#000000
borderStyle	solid

D:\geronimo-tomcat6-jee5-2.12\bin>deploy --user system --password manager deploy \tmp\db2-plan.xml ..\repository\org\tranql\tranql-connector-db2-raxa\1.3\tranql-connector-db2-raxa-1.3.rar
Using GERONIMO_BASE:   D:\geronimo-tomcat6-jee5-2.12
Using GERONIMO_HOME:   D:\geronimo-tomcat6-jee5-2.12
Using GERONIMO_TMPDIR: D:\geronimo-tomcat6-jee5-2.12\var\temp
Using JRE_HOME:        C:\Java\jdk1.5.0_06\\jre
    Deployed console.dbpool/DB2_ds/1.0/rar

...

Child pages

Versions Compared

Old Version 4

New Version 5

Key

Using the Geronimo Administration Console