Have been looking a bit more at this and seems that, according to the 
jboss-ds_1_5.dtd
, the local-tx-datasource type of datasource takes a url-delimiter. And when I 
deploy with 

  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>jdbc/BOB-DS</jndi-name>
  |     
<connection-url>jdbc:oracle:thin:@db1:1521:db1|jdbc:oracle:thin:@db2:1521:db2</connection-url>
  |     <url-delimiter>|</url-delimiter>
  | 
  |     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |     <user-name>USERNAME</user-name>
  |     <password>PASSWORD</password>
  | 
  |     <min-pool-size>2</min-pool-size>
  |     <max-pool-size>20</max-pool-size>
  | 
  |     <check-valid-connection-sql>select 1 from 
dual</check-valid-connection-sql>
  |     
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  |     
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  |   </local-tx-datasource>
  | </datasources>
  | 
  | 

All seems fine. Though I have NOT tested the failover capability.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4216545#4216545

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4216545
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to