You need a different license to access DB2 on z/OS. The one I used (i.e.  db2jcc_license_cu.jar) was for DB2 on distributed platforms(UNIX/Linux/Windows). Copy db2jcc_license_cuz.jar to the repository and rename as you did before and then add the following dependency to your plan (note that this jar has the license for accessing DB2 on z/OS and iSeries). Hope this helps.

<dependency>
        <uri>db2/db2jcc_license_cuz/8.2/jar</uri>
 </dependency>



On 3/22/06, VARIN, FRANCIS A. < FVARIN@amica.com> wrote:

David,

Thanks for your reply…you hit the nail right on the head. That was the problem…we checked the articles that we have been using as a guide and, sure enough, the error is repeated in there as well. We tried your suggestion and we are now by that particular problem.

 

We're now fighting with what drivers should actually be used since we have DB connect middleware in place to proxy the connection to our mainframe based DB2 dababases. It seems that we need to configure this a slightly different way than is suggested by the articles. Any ideas?

 

When we try to connect using the universal connector we receive an exception that indicates we do not have the proper license to connect to zOS.

 

Francis A. Varin, M.S. 
IT Architect II 
Corporate Information Systems
Amica Mutual Insurance Company
1-800-652-6422 ext. 24536 
http://www.amica.com


From: David Carew [mailto:dccarew@gmail.com]
Sent: Wednesday, March 22, 2006 11:45 AM
To: user@geronimo.apache.org
Subject: Re: Configurint Geronimo to use DB2

 

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>


**********************************************************
This email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.
If you have received this email in error please notify
postmaster@amica.com
and the sender of the message. Thank you.
**********************************************************