I trie to config my Jboss 3.22 with MSSQL Server by the MSSQL_XA_DS.xml (Successfully config with MSSQL_DS.xml).
First , I enabled the JTA on MS SQL server as the Microsoft description . copy the jdbcsql.dll in to the SQL_SERVER_ROOT/binn, run the instjdbc.sql, and so on.
Then I rewrote the MSSQL_XA_DS.xml to fit the my configuration. but I stilll got the following error message, when I ran the Example cmp-cd.
cmp-cd-list:
main:
[java] org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is:
[java] org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=beta//29, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=beta//29, BranchQual=] status=STATUS_NO_TRANSACTION)
BUILD SUCCESSFUL
Total time: 6 seconds
Yes, I meet this problem too. And when i used mssql-ds.xml, all is ok. i confused why this happened?