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.