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

How to specify database instance name in XADatasource

techmonster Apr 28, 2011 3:00 PM

Hi,

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:

jdbc:jtds:sqlserver://lndk2344;instance=hedge_uat

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

-Steve

1. How to specify database instance name in XADatasource

john.miller Apr 28, 2011 6:45 PM (in response to techmonster)

The xa-datasource-property "DatabaseName" specifies the name of the database instance.
Actions
2. How to specify database instance name in XADatasource

wdfink Apr 29, 2011 5:56 AM (in response to techmonster)

If you look into the docs/examples/jca folder of your JBoss installation you will find examples for a lot of databases.
Also you will find a wiki here : http://community.jboss.org/wiki/configdatasources
Actions
3. How to specify database instance name in XADatasource

techmonster Apr 29, 2011 11:46 AM (in response to wdfink)

Thanks for your replies.

@John: I tried specifying instance name in "DatabaseName" property but it did not work. This is how i did it:

<xa-datasource-property name="DatabaseName">hedge_uat\db_name</xa-datasource-property>

I also tried: <xa-datasource-property name="DatabaseName">hedge_uat\\db_name</xa-datasource-property>

Could you please tell me what am I doing wrong here ?

@Wolf: I am already using the datasource xml file from examples folder. But the wiki doesnt talk anything about how to specify instance name while accessing database. Please suggest.

-Steve
Actions
4. How to specify database instance name in XADatasource

wdfink Apr 29, 2011 4:37 PM (in response to techmonster)

IS databasename not hedge_uat in your case? I'm not familar with MSSQL, but I think '/' and '\' is not valid for DatabaseName!?
Actions
5. How to specify database instance name in XADatasource

techmonster Apr 29, 2011 5:28 PM (in response to wdfink)

Hi Wolf,
lndk2344 is server name. hedge_uat is the instancename. db_name is name of database. How do i specify this in xa-datasource descriptor file.

-Steve
Actions
6. How to specify database instance name in XADatasource

wdfink Apr 30, 2011 8:16 AM (in response to techmonster)

Sorry , I don't know it.

But your XA driver should have getter and setter for all properties, you should find this by having a decompiler (like Eclipse) to view the methods of the class.
This might help you if you have no other vendor documentation of the driver
Actions
7. How to specify database instance name in XADatasource

techmonster May 10, 2011 9:44 AM (in response to wdfink)

Anybody ?
Actions
8. Re: How to specify database instance name in XADatasource

drowsyj May 7, 2015 5:53 PM (in response to techmonster)

I had this problem today and the solution was to have the server and instance names thus with a single slash:
<xa-datasource-property name="ServerName">servername\instancename</xa-datasource-property>
and to remove the PortNumber property altogether. Something about the server using the instance name to resolve what port number it should use, but if PortNumber is set it will use that instead.
Actions
9. Re: How to specify database instance name in XADatasource

wickedfleche Dec 15, 2015 3:53 PM (in response to techmonster)

Hi Steve, Try this:

                   <xa-datasource-property name="Instance">
                        DB1
                    </xa-datasource-property>

Thanks,
Tim
Actions

Go to original post