Hi,

I am having an issue deploying a ha-local-tx-datasource into JBoss 5.0.1 (Java 6 version). local-tx-datasource works fine but when I deploy a ha datasource nothing seems to happen, i.e. nothing is logged to console, and the file appears in the web-console, but no datasource.

This is the xml, from my -ds.xml file:

<datasources>
 <ha-local-tx-datasource>
 <jndi-name>jdbc/DBConnection</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>

 <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
 <min-pool-size>2</min-pool-size>

 <!-- The maximum connections in a pool/sub-pool -->
 <max-pool-size>20</max-pool-size>

 <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered -->
 <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>

 <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
 <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>

 <!-- Checks the Oracle error codes and messages for fatal errors -->
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

 <!-- sql to call when connection is created
 <new-connection-sql>some arbitrary sql</new-connection-sql>
 -->

 </ha-local-tx-datasource>

</datasources>