Pool for DB2 JDBC 2.0 driver installation ?

[zeroman]

Does anybody sucessfull installation db2 connection pool in the 3.0b version ?
Could somebody give a clue for pool settings ?
I have that in my db2-service.xml in the /deploy dir.

<classpath archives="db2java.zip"/>
Also I have in the run.bat additional paths for db2 runtime libs like
JBOSS_CLASSPATH=;c:/jdk1.3\lib\tools.jar;run.jar;C:\Program Files\SQLLIB\java\ru
ntime.zip;C:\Program Files\SQLLIB\java\sqlj.zip;C:\Program Files\SQLLIB\bin

<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="jboss.jca:service=ConnectionFactoryLoader,name=MinervaXACMFactory">
<attribute name="ManagedConnectionFactoryProperties">
ConnectionURL=jdbc:db2://rs6000:50000/JPYX
DriverClass=COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
UserName=jp
Password=jp
</attribute>
<attribute name="JndiName">jdbc/INFRA</attribute>
<attribute name="TransactionManagerName">java:/TransactionManager</attribute>

<depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</depends>
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends>
<attribute name="PrincipalMappingClass">
org.jboss.resource.security.ManyToOnePrincipalMapping
</attribute>
<attribute name="PrincipalMappingProperties">
UserName=jp
Password=jp
</attribute>

I've got this errors.

23:34:43,221 INFO [jdbc/INFRA] PrincipalMapping properties set to: {Password=jp, UserName=jp}
23:34:43,281 ERROR [jdbc/INFRA] Unable to create ManagedConnection:
javax.resource.ResourceException: Unable to create DB connection for url: jdbc:db2://rs6000:50000/JPYX, user: jp, exception: java.sql.SQLException: No suitable driver
at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.createManage
dConnection(JDBCManagedConnectionFactory.java:392)
at org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.createObject(
ManagedConnectionPoolFactory.java:97)
...
and very lonf stack trace...

As I can suppose something wrong then ResourceAdapter try to create connection. May be I use a wrong ConnectionFactoryLoader or ResourceAdapterName ?

Thank for any help.

[davidjencks]

You have a choice of trying to get connections from a Driver or an XADataSource. There's no way to use external pooling with jboss transaction management; generalized, this is one of the main points of the jca architecture.

So: either change the DriverClass to a Driver implementation, and use local (1pc) transactions

or

find an XADataSource implementation and use the Minerva XATransaction resource adapter and corresponding COnnectionFactoryLoader.

AFAIK no one has tried to use an xa driver with jboss 3, except the firebird jca-jdbc driver which doesn't need a jca wrapper.