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

Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion "Re: How to configure connection pool for two databases??" To view the discussion, visit: https://community.jboss.org/message/759018#759018 -------------------------------------------------------------- My example looks like this: +<datasources>+ +  <xa-datasource>+ +    <jndi-name>MSSQLXADS</jndi-name>+ +    <!-- uncomment to enable interleaving <interleaving/> -->+ +    <isSameRM-override-value>false</isSameRM-override-value>+ +    <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>+ +    <xa-datasource-property name="ServerName">myserver</xa-datasource-property>+ +    <xa-datasource-property name="DatabaseName">mydatabase</xa-datasource-property>+ +    <xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>+ +    <xa-datasource-property name="User">myuser</xa-datasource-property>+ +    <xa-datasource-property name="Password">mypassword</xa-datasource-property>+ +      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->+ +      <metadata>+ +         <type-mapping>MS SQLSERVER2000</type-mapping>+ +      </metadata>+ +  </xa-datasource>+ +</datasources>+ Maybe you have some hidden sequences? Or the server name could not contain \\, try / instead. I don't know the exact syntax here :( Maybe this https://community.jboss.org/docs/DOC-12242 wiki helps -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/759018#759018] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]