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

[mcrandal]

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>
  | 

If it helps this file works perfectly in JBoss 4.0.3

Thanks for your help

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

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4214626