JBoss Community

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

created by hiren kesariya in Datasource Configuration - View the full discussion

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

Start a new discussion in Datasource Configuration at Community