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.
Is there anything else I have to configure?
Thanks.