0 Replies Latest reply on Mar 17, 2003 10:46 PM by Agustin Sanchez

    JTA is not support when selectMethod=direct

    Agustin Sanchez Newbie

      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.