I am hoping someone can assist me. I have been working through setting up JBoss 4.0.5 with SQL Server2000 using a XA transaction. I am really new to JBOSS.. :-)
I have gotten the data source setup using this information in my -ds.xml.
<datasources> <xa-datasource> <jndi-name>jdbc/pidbdev</jndi-name> <track-connection-by-tx/> <isSameRM-override-value>false</isSameRM-override-value> <xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class> <xa-datasource-property name="ServerName">me_server</xa-datasource-property> <xa-datasource-property name="DatabaseName">me_db</xa-datasource-property> <xa-datasource-property name="SelectMethod">cursor</xa-datasource-property> <xa-datasource-property name="User">p1</xa-datasource-property> <xa-datasource-property name="Password">p1</xa-datasource-property> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <metadata> <type-mapping>MS SQLSERVER2000</type-mapping> </metadata> <check-valid-connection-sql>SELECT * FROM invalidate</check-valid-connection-sql> </xa-datasource> </datasources>
15:14:16,269 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalI d=rray-wxp/1, BranchQual=, localId=1] errorCode=XAER_RMERR javax.transaction.xa.XAException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_commit (4 0000000) returns -4 at com.microsoft.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)