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:[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006
11:45 AM
To: [email protected]
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
[EMAIL PROTECTED]
and the sender of the message. Thank you.
**********************************************************
