Hi Igor.
I applied the patch and initially found the
XAResourceTest tests ran successfully a number of times. Ive found that after
running the XAResourceTest, if l leave SQL Server running, stop and start
JBoss and then run the test again, the testSimpleCommitTx test fails (see the
log extract below). Ive started having a look at it - if you dont think its
worth the effort let me know. Given the senario the exception occurs under and
the presence of static objects, is it possible that either the MS JDBC
drivers or the VM could be hanging onto something that is messing up the
works?
Jamie
line 238 : tx.delistResource(xares, XAResource.TMSUCCESS);
line 239:
tx.commit();
Log Extract:
2002-09-30 20:20:36,987 WARN
[org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl
[FormatId=257, GlobalId=burns01//17, BranchQual=]
errorCode=XAER_RMERR
javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_end (4000000) returns -6 at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source) at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.end(Unknown Source) at com.microsoft.jdbcx.base.BaseXAResource.end(Unknown Source) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:118) at org.jboss.tm.TransactionImpl.endResource(TransactionImpl.java:1353) at org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.java:727) at org.jboss.test.jca.tm.XAResourceTest.testSimpleCommitTx(XAResourceTest.java:238) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:548) at org.jboss.jmx.adaptor.rmi.RMIAdaptorImpl.invoke(RMIAdaptorImpl.java:265) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:536) 2002-09-30 20:20:36,997 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=burns01//17, BranchQual=] errorCode=XAER_RMERR javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_end (4000000) returns -6 at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source) at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.end(Unknown Source) at com.microsoft.jdbcx.base.BaseXAResource.end(Unknown Source) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:118) at org.jboss.tm.TransactionImpl.endResource(TransactionImpl.java:1353) at org.jboss.tm.TransactionImpl.endResources(TransactionImpl.java:1428) at org.jboss.tm.TransactionImpl.checkStatusForPrepare(TransactionImpl.java:1917) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:308) at org.jboss.test.jca.tm.XAResourceTest.testSimpleCommitTx(XAResourceTest.java:239) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:548) at org.jboss.jmx.adaptor.rmi.RMIAdaptorImpl.invoke(RMIAdaptorImpl.java:265) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:536) 2002-09-30 20:20:37,007 INFO [org.jboss.test.jca.tm.XAResourceTest] Exception in test javax.transaction.RollbackException: Already marked for rollback at org.jboss.tm.TransactionImpl.checkStatusForPrepare(TransactionImpl.java:1923) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:308) at org.jboss.test.jca.tm.XAResourceTest.testSimpleCommitTx(XAResourceTest.java:239) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:548) at org.jboss.jmx.adaptor.rmi.RMIAdaptorImpl.invoke(RMIAdaptorImpl.java:265) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:536) 2002-09-30 20:20:37,598 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=burns01//22, BranchQual=] errorCode=XAER_RMERR javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_end (4000000) returns -6 at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source) at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.end(Unknown Source) at com.microsoft.jdbcx.base.BaseXAResource.end(Unknown Source) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:118) at org.jboss.tm.TransactionImpl.endResource(TransactionImpl.java:1353) at org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.java:727) at org.jboss.test.jca.tm.XAResourceTest.test590816(XAResourceTest.java:423) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:548) at org.jboss.jmx.adaptor.rmi.RMIAdaptorImpl.invoke(RMIAdaptorImpl.java:265) at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:536) 2002-09-30 20:20:37,608 INFO [org.jboss.test.jca.tm.XAResourceTest] Exception in test java.lang.Exception: could not delist xares in tx1 at org.jboss.test.jca.tm.XAResourceTest.test590816(XAResourceTest.java:425) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:548) at org.jboss.jmx.adaptor.rmi.RMIAdaptorImpl.invoke(RMIAdaptorImpl.java:265) at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:536) 2002-09-30 20:25:37,539 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=burns01//22, BranchQual=] timed out. status=STATUS_MARKED_ROLLBACK 2002-09-30 20:25:37,549 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=burns01//23, BranchQual=] timed out. status=STATUS_ACTIVE
|
Title: FW: [JBoss-dev] XADataSource wrapper for JBoss 4
- Re: [JBoss-dev] XADataSource wrapper for JBoss... David Jencks
- Re: [JBoss-dev] XADataSource wrapper for JBoss... Igor Fedorenko
- Re: [JBoss-dev] XADataSource wrapper for J... Jamie Burns
- Re: [JBoss-dev] XADataSource wrapper ... David Jencks
- Re: [JBoss-dev] XADataSource wrapper for J... Jamie Burns
- Re: [JBoss-dev] XADataSource wrapper ... David Jencks
- Re: [JBoss-dev] XADataSource wrapper ... Jamie Burns
- Re: [JBoss-dev] XADataSource wrap... Igor Fedorenko
- Re: [JBoss-dev] XADataSource wrap... David Jencks
- Re: [JBoss-dev] XADataSource wrap... Igor Fedorenko
- Re: [JBoss-dev] XADataSource wrapper for JBoss 4 Jamie Burns
- Re: [JBoss-dev] XADataSource wrapper for JBoss 4 David Jencks
- Re: [JBoss-dev] XADataSource wrapper for JBoss 4 Jamie Burns
- Re: [JBoss-dev] XADataSource wrapper for JBoss... Jamie Burns
- Re: [JBoss-dev] XADataSource wrapper for J... David Jencks