[jboss-user] [JCA/JBoss] - Re: Jboss 5.0.1 & ha-local-tx-datasource

[mcrandal]

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