4 Replies Latest reply on May 22, 2003 4:46 AM by Davide

    XADataSource on AS/400

    Christian Lauer Newbie

      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?

        • 1. Re: XADataSource on AS/400
          David Jencks Master

          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...

          • 2. Re: XADataSource on AS/400
            Christian Lauer Newbie

            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

            • 3. Re: XADataSource on AS/400
              Davide Newbie

              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

              • 4. Re: XADataSource on AS/400
                Davide Newbie

                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