1 Reply Latest reply on Feb 26, 2002 12:35 AM by David Jencks

    Pool for DB2 JDBC 2.0 driver installation ?

    Blandger Newbie

      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.

        • 1. Re: Pool for DB2 JDBC 2.0 driver installation ?
          David Jencks Master

          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.