I have configured the XA-datasources on sql server by the following ways:
enter code here
<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
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 inorder to fetch from "my database "
My loginUserName is the owner of both master schema and "mydatabase" schema and have created Role SqlJDBCXA user both in master and "mydatabase".
Referred the following but couldnot help Exception with MS-SQL Server,JDBC and XA Transactions
Can anyone Suggest? ThankYou
Aucun commentaire:
Enregistrer un commentaire