1 Reply Latest reply on Mar 29, 2004 8:00 AM by Adrian Brock

    Strange behaviour with db2 xa datasource

    eolo Newbie

      Hi all,

      I configured db2 xa datasource in jboss 3.2.3. My purpose is to work with distributed transaction between jms and jdbc connections. The transaction is container managed. Practically I developed an MDB that write in a DB. It seems work fine but under a heavy load of incoming JMS messages I receive two different and strange error

      Db2 error:

      COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL30020N Execution failed because
      of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements: Reason Code "0x124C". SQLSTATE=58009


      And jboss error

      ERROR [StdServerSession] failed to commit/rollback
      org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=siria//6821, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.transaction.xa.XAException)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:413)
      at org.jboss.tm.TxManager.commit(TxManager.java:141)
      at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:341)
      at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:633)
      at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:433)
      at org.jboss.mq.SpySession.run(SpySession.java:298)
      at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:180)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:732)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: javax.transaction.xa.XAException
      at COM.ibm.db2.jdbc.app.DB2XAResource.throwXAException(DB2XAResource.java:288)
      at COM.ibm.db2.jdbc.app.DB2XAResource.end(DB2XAResource.java:136)
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:156)
      at org.jboss.tm.TransactionImpl.endResource(TransactionImpl.java:1205)
      at org.jboss.tm.TransactionImpl.endResources(TransactionImpl.java:1278)

      I receive this error messages only 1 over 100 JMS messages received and only in a heavy load regime of incoming JMS messages.

      Some help?
      Thanks
      Luca

        • 1. Re: Strange behaviour with db2 xa datasource
          Adrian Brock Master

          This is not very informative:

          Caused by: javax.transaction.xa.XAException
          at COM.ibm.db2.jdbc.app.DB2XAResource.throwXAException(DB2XAResource.java:288)
          at COM.ibm.db2.jdbc.app.DB2XAResource.end(DB2XAResource.java:136)

          Try adding <track-connection-by-tx>true</track-connection-by-tx>
          (if you don't already have it) to your db2-xa-ds.xml or whatever you called it.

          Also enable TRACE logging for org.jboss.tm to see whether it shows a more
          informative message.

          Regards,
          Adrian