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