Hi. I'm trying to execute an XA transaction from a Stateless Session Bean using MSSQL Server. I've modified the mssql-xa-service.xml that comes with jboss-3.2.0RC3 in /doc/examples/jca. Whenever I try to execute a transaction I get this exception:
00:52:15,235 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 20 00 Driver for JDBC]JTA is not support when selectMethod=direct. Switch to select Method=cursor.);
I'm attaching a copy of the mssql-xa-service.xml file.