0 Replies Latest reply on Mar 13, 2016 11:38 PM by Sushmitha P

    Configuring XA datasources on SQL server for jboss eap6.4

    Sushmitha P Newbie

      I have configured the XA-datasources on sql server by the following ways:


        <xa-datasource jndi-name="java:/jdbc/MyDataSource" pool-name="SQLServerPool">


         <xa-datasource-property name="ServerName">localhost</xa-datasource-property>

         <xa-datasource-property name="DatabaseName">mydb</xa-datasource-property>

         <xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>









         <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>




         <driver name="sqlserver" module="com.microsoft">





      And enabled XA transaction database side by following

      How a DBA can confirm if Microsoft JDBC XA transactions are set | Data Access Technologies

      But the Database I have been using for my project is not a master database .Since XA-transactions are enabled on master, by default data is taking from master db and not from my database.

      Is it that I need to configure XA-transactions on "my database" for the problem to be resolved?

      How to give the server name under <xa-datasource-property> inorder to fetch from "my database "

      Can anyone Suggest?