[jboss-user] [Datasource Configuration] - Re: How to configure connection pool for two databases??

[hiren kesariya]

hiren kesariya [https://community.jboss.org/people/jk.hiren] created the discussion

"Re: How to configure connection pool for two databases??"

To view the discussion, visit: https://community.jboss.org/message/759002#759002

--------------------------------------------------------------
Yes, the class +com.microsoft.sqlserver.jdbc.SQLServerXADataSource+ is packed in the jar file.
I am using "jboss-5.1.0.GA"

I went as per your instructions and added 
+<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>+.  in the -xa-ds.xml file for sql server 2005,
but now I am getting 

*"org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 1**\MSSQL2008R2* *^)"*
 as my server name in url is     <xa-datasource-property name="ServerName">hello-welcome\\MSSQL2008R2</xa-datasource-property>


please help with this.
Thanx.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/759002#759002]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120911/dde23475/attachment.html