How to specify database instance name in XADatasource

[techmonster]

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

[john.miller]

The xa-datasource-property "DatabaseName" specifies the name of the database instance.

[wdfink]

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

[techmonster]

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

[wdfink]

IS databasename not hedge_uat in your case? I'm not familar with MSSQL, but I think '/' and '\' is not valid for DatabaseName!?

[techmonster]

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

[wdfink]

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

[techmonster]

Anybody ?

[drowsyj]

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.

[wickedfleche]

Hi Steve, Try this:

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

                        DB1

                    </xa-datasource-property>

Thanks,

Tim