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&containerType=14&container=2077]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user