XADataSource on AS/400

[lauerc]

I'm trying to set up an XA DataSource configuration using the XADataSource implementation of the AS/400 Toolbox for JAVA. This implementation does not support the XAResource flags TMSUSPEND on resource end and TMRESUME on resource start, it throws XAException whenever you try to pass a value different from TMSUCCESS to the end method or a value different from TMNOFLAGS to the start method. I've written a wrapper to filter out these calls, and now everything works without any exceptions, but the transaction handling does'nt work proper now (which is no wonder).
Does anybody have an ID to get into the benefits of XA with a driver like that, which doesn't fully support XA?

[davidjencks]

Which jboss?

I believe in all current versions you can set the TrackConnectionsByTx flag and jboss will not suspend and resume your xaresources.

3.2+ include <track-connections-by-tx/>
3.0 include true

I think there are examples in case I got the exact names wrong...

[lauerc]

Hi David,

first of all, many thanx for your quick reply!

I've applied the configuration changes according to your advice and - wow - it seems to works perfectly!!!!

Best regards,
Christian

[pozzad]

Hi Christian,
I need your help about the AS400 XA configuration.
Starting from JBoss3.2.1, and using the new xonfiguration syntax, I encountered many problems: all my transactions block and when the timeout is reached, an Exception is thrown....It seems that my AS400 libraries are "not passed" to the DataSource

This is my configuration file:


<xa-datasource>
<jndi-name>XAAS400DS</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">10.1.1.5</xa-datasource-property>
<xa-datasource-property name="Libraries">CRPDTA,G8_CNVOW</xa-datasource-property>
<xa-datasource-property name="User">jde</xa-datasource-property>
<xa-datasource-property name="Password">jde</xa-datasource-property>
</xa-datasource>


Can you tell me if there's something wrong?

Thanks in advance

Davide

[pozzad]

Hi Christian,
I need your help about the AS400 XA configuration.
Starting from JBoss3.2.1, and using the new xonfiguration syntax, I encountered many problems: all my transactions block and when the timeout is reached, an Exception is thrown....It seems that my AS400 libraries are "not passed" to the DataSource

This is my configuration file:


<xa-datasource>
<jndi-name>XAAS400DS</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">10.1.1.5</xa-datasource-property>
<xa-datasource-property name="Libraries">CRPDTA,G8_CNVOW</xa-datasource-property>
<xa-datasource-property name="User">jde</xa-datasource-property>
<xa-datasource-property name="Password">jde</xa-datasource-property>
</xa-datasource>


Can you tell me if there's something wrong?

Thanks in advance

Davide