The xa-datasource-property "DatabaseName" specifies the name of the database instance.
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
Thanks for your replies.
@John: I tried specifying instance name in "DatabaseName" property but it did not work. This is how i did it:
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.
IS databasename not hedge_uat in your case? I'm not familar with MSSQL, but I think '/' and '\' is not valid for DatabaseName!?
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.
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
I had this problem today and the solution was to have the server and instance names thus with a single slash:
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.
Hi Steve, Try this: