9 Replies Latest reply on Dec 15, 2015 3:53 PM by wickedfleche

    How to specify database instance name in XADatasource



            This is my first post in this forum. Here is my requirement: We have a MSSQL database instance running on a server. I wrote a simple javaprogram to connect to using jtds driver. This works fine. Here is the connection string i used:




      As you can see from above, our server name is: lndk2344 and instance name is: hedge_uat


      When i setup XADatasource in jboss, how do i specify the instance name. Using xa-datasource-property i can specify servername, databasename, port, username, password but I dont see any property to specify instance name like in above scenario when i have multiple database instances running on the same server.


      Please suggest