lundi 14 mars 2016

Configuration of XA dataSources on Jboss eap 6.4

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

http://ift.tt/1nIkdd6

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

http://ift.tt/1pp9Blc

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