DB2 XA connection problem - Non XA works

[jshrinivas]

Hello,

I am trying to use IBM DB2 XA datasource with JBoss 4.0.5-SP1 and have modified db2-xa-ds.xml. I get following error during JBoss startup:

Reason: org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.ibm.db2.jcc.b.SqlException: Failure in loading T2 native library db2jcct2); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.ibm.db2.jcc.b.SqlException: Failure in loading T2 native library db2jcct2)))

If I use non XA datasource it works fine; so I think it is not a problem with drivers not being in the CLASSPATH. Also JBoss and DB2 machines are on Linux platform.

Is there anything that I need to install (native libs probably) to get XA driver working ?

Thanks,
-Shrinivas

[weston.price]

Yep. The db2jcc driver does not support native XA. As a result, you have to install the DB2 client libraries to get XA support.

[jshrinivas]

Hi,

Thanks for your reply. I am looking for the client libraries and will post an update on how it goes.

In the mean time I want to make sure if there is actually a problem or I am just missing something here. From the exception it looks like it is trying to use Type 2 driver (T2 in the error) but isn't db2jcc.jar Type 4 driver? Is there any way you can specify JBoss to use Type 4 URL (as I think thats the only way it decides whether to use Type 2 or Type 4). Here is what I have specified currently in the db2-xa-ds.xml:

<xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class>
<xa-datasource-property name="DatabaseName">db_name</xa-datasource-property>
<xa-datasource-property name="ServerName">db_host</xa-datasource-property>
<xa-datasource-property name="PortNumber">db_port</xa-datasource-property>
<xa-datasource-property name="User">db_user</xa-datasource-property>
<xa-datasource-property name="Password">db_pass</xa-datasource-property>


Thanks,
-Shrinivas

[weston.price]

The db2jcc driver is Type4, but XA support is not provided in a Type4 configuration. As opposed to Oracle, DB2 relies on native code to support XA functionality. As a result, the DB2 client has to be installed. You can indeed use Type4 configuration syntax, but you still need the libraries to support XA.

[jshrinivas]

Some platform details:

DB2 - V 8.2.0 on RHEL 4
Drivers: IBM DB2 JDBC Universal Driver Architecture 2.3.63
AMD_64 hardware

JBoss 4.0.5-SP1-ejb3 on RHEL 4
built from source using Sun JDK 1.5 U9

[jshrinivas]

Thanks for your quick reply. I will try with installing DB2 client.

Appreciate your help

-Shrinivas

[weston.price]

No problem. It's a known limitation of the db2jcc driver. More can be found here:

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0402kitchlu/

[jshrinivas]

I tried installing the DB2 Application Development Client (http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_linuxamd2664bit.html ), configured the client to connect to DB2 server, tested the connection through DB2 CLI and it works through CLI. However, I still get the same error during JBoss startup. Am I missing something here.

Thanks,
-Shrinivas

[weston.price]

If using the Type4 driver I believe (from what I remember) you have to tell the datasource to treat the resource as Type2. This should be a configuration property.

Try this:

<xa-datasource-property name="DriverType">2</xa-datasource-property>

If he still can find the client libraries then you may have to modify your LD_LIBRARY_PATH or other environment variable.

[jshrinivas]

Thanks again for your help. Here are the things that I tried:

"DriverType" = 2 - still failed to load native libs

"DriverType" = 2 and LD_LIBRARY_PATH set to DB_INSTANCE/lib(64)/ - SQL10007N Message "-1390" could not be retrieved. Reason code: "3"

"DriverType" = 2, LD_LIBRARY_PATH set and defined DB2INSTANCE env var (source db2profile should take care of this) - XA connection established

"DriverType" = 4 - JBoss starts up without DB conn errors.

Eventhough last 2 options are working in theory I am getting Tx related errors esp. RollbackException, Commit errors etc, but I guess that could be just because of the underlying J2EE application.

I just thought it would be helpful to those who face this issue in future.

Thanks,
-Shrinivas

[weston.price]

I just fired up my instance of DB2. I will take a look.

[weston.price]

I was able to get this to run on an AMD64 system with no issues. Note, DB2 seems to want it's libraries first in the LD_LIBRARY_PATH. Also, use of the db2profile script seems to be required.

[jshrinivas]

Thanks for your help. It works with native libraries now.

Thanks again
-Shrinivas