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&...]