Bugs item #690506, was opened at 2003-02-21 00:28
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=690506&group_id=22866
Category: JBossTX
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Marc Prud'hommeaux (mprudhom)
Assigned to: Nobody/Anonymous (nobody)
Summary: 3.2.0RC2 xa_start error -8 with SQLServer
Initial Comment:
When attempting to commit an XA transaction using
SQLServer (using the MS driver, configured using the
mssql-xa-ds.xml DS configured in the examples), it
works fine the first time. The second time, it throws
"javax.transaction.xa.XAException:
[Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]xa_start (0) returns -8".
According to section 4.5 of the X/Open XA
specification, -8 indicates "the XID already exists",
which indicates that JBoss may be re-using XIDs
inappropriately.
The exact same code worked for JBoss 3.2.0 beta 3.
System info:
[chance mprudhom]$ java -version
java version "1.3.1"
Java(TM) 2 Runtime Environment, Standard Edition (build
1.3.1-root_1.3.1_020714-12:46)
Java HotSpot(TM) Client VM (build 1.3.1_03-69, mixed mode)
[chance mprudhom]$ uname -a
Darwin chance.local. 6.4 Darwin Kernel Version 6.4: Wed
Jan 29 18:50:42 PST 2003;
root:xnu/xnu-344.26.obj~1/RELEASE_PPC Power Macintosh
powerpc
Stack trace:
19:29:19,487 WARN [TransactionImpl] XAException:
tx=TransactionImpl:XidImpl [FormatId=257,
GlobalId=chance.local.//8, BranchQual=]
errorCode=XAER_RMERR
javax.transaction.xa.XAException: [Microsoft][SQLServer
2000 Driver for JDBC][SQLServer]xa_start (0) returns -8
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown
Source)
at
com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown
Source)
at
com.microsoft.jdbcx.base.BaseXAResource.start(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:110)
at
org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1137)
at
org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:624)
at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:461)
at
org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:359)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:546)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:837)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at
com.solarmetric.kodo.impl.jdbc.runtime.DataSourceConnector.getConnection(DataSourceConnector.java:61)
at
com.solarmetric.kodo.impl.jdbc.schema.DBDictionaryFactory.getDictionary(DBDictionaryFactory.java:179)
at
com.solarmetric.kodo.impl.jdbc.JDBCSimpleConfiguration.getDictionary(JDBCSimpleConfiguration.java:336)
at
com.solarmetric.kodo.impl.jdbc.JDBCPersistenceManagerFactory.registerClassInternal(JDBCPersistenceManagerFactory.java:454)
at
com.solarmetric.kodo.impl.jdbc.JDBCPersistenceManagerFactory.registerClass(JDBCPersistenceManagerFactory.java:337)
at
com.solarmetric.kodo.impl.jdbc.RegisterListener.registerClass(RegisterListener.java:53)
at
javax.jdo.spi.JDOImplHelper.registerClass(JDOImplHelper.java:269)
at
com.solarmetric.kodo.runtime.AllFieldTypesTest.<clinit>(AllFieldTypesTest.java)
at
XAEnvironmentTest.testXATransaction(XAEnvironmentTest.java:99)
at
XAEnvironmentTest.testXATransaction(XAEnvironmentTest.java:72)
at
XAEnvironmentTest.start(XAEnvironmentTest.java:323)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
at $Proxy11.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy5.start(Unknown Source)
at
org.jboss.deployment.SARDeployer.start(SARDeployer.java:231)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:827)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:639)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:612)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy7.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:404)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:545)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:195)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:268)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy5.start(Unknown Source)
at
org.jboss.deployment.SARDeployer.start(SARDeployer.java:231)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:827)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:639)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:612)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:596)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy6.deploy(Unknown Source)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:332)
at
org.jboss.system.server.ServerImpl.start(ServerImpl.java:239)
at org.jboss.Main.boot(Main.java:155)
at org.jboss.Main$1.run(Main.java:393)
at java.lang.Thread.run(Thread.java:491)
----------------------------------------------------------------------
>Comment By: Marc Prud'hommeaux (mprudhom)
Date: 2003-02-24 17:31
Message:
Logged In: YES
user_id=33016
Actually, I think this is user error on my part; an
underlying SQL exception occured and was not being reported.
Recommend that this bug be closed.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=690506&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development