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:


      <datasources>

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

         <driver>sqlserver</driver>

         <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>

         <security>

         <user-name>admin</user-name>

         <password>admin</password>

         </security>

         <xa-pool>

         <is-same-rm-override>false</is-same-rm-override>

         </xa-pool>

         <validation>

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

         </validation>

        </xa-datasource>

        <drivers>

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

         <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

         </driver>

        </drivers>

      </datasources>


      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?

      ThankYou.