Re: Configurint Geronimo to use DB2

[David Carew]

It appears you're using the Type 2 DB2 JDBC Driver. I think that's deprecated so I would avoid using it. I would recommmend using the DB2 Type 4 JDBC Driver. Here's an example of a plan that I embedded in my geronimo-application.xml file. Note that I renamed the DB2 jars to db2jcc-8.2.jar and db2jcc_license_cu-8.2.jar after putting them in ${GERONIMO_HOME}/repository/db2/jars. Hope this helps.

 <ext-module>
        <connector>WebBankDataSource</connector>
        <external-path>tranql/tranql-connector/1.1/rar</external-path>
        <connector
            xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector "
            configId="WebBankDB2Pool"
            parentId="geronimo/j2ee-server/1.0/car">

    <dependency>
        <uri>db2/db2jcc/8.2/jar</uri>
    </dependency>
    <dependency>
        <uri>db2/db2jcc_license_cu/8.2/jar</uri>
    </dependency>

       <resourceadapter>
       <outbound-resourceadapter>

          <connection-definition>
           <connectionfactory-interface>
            javax.sql.DataSource
           </connectionfactory-interface>
        <connectiondefinition-instance>
           <name>WebBankDB2Pool</name>
            <config-property-setting name="UserName">
                your_userid
            </config-property-setting>
            <config-property-setting name="Password">
                your_password
            </config-property-setting>
            <config-property-setting name="Driver">
                com.ibm.db2.jcc.DB2Driver
            </config-property-setting>
            <config-property-setting name="ConnectionURL">
                jdbc:db2://localhost:50000/your_db
            </config-property-setting>

            <config-property-setting name="CommitBeforeAutocommit">
                true
            </config-property-setting>
            <config-property-setting name="ExceptionSorterClass">
                org.tranql.connector.NoExceptionsAreFatalSorter
            </config-property-setting>
            <connectionmanager>
                <local-transaction />
                <single-pool>
                   <max-size>10</max-size>
                   <min-size>0</min-size>
                   <blocking-timeout-milliseconds>
                        5000
                   </blocking-timeout-milliseconds>
                   <idle-timeout-minutes>
                        30
                   </idle-timeout-minutes>
                   <match-one />
                </single-pool>
            </connectionmanager>
           </connectiondefinition-instance>
        </connection-definition>
       </outbound-resourceadapter>
      </resourceadapter>
        </connector>
    </ext-module>