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

[Wolf-Dieter Fink]

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]

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