4 Replies Latest reply on May 7, 2009 12:34 AM by Vicky Kak

    Jboss 5.0.1 & ha-local-tx-datasource

    Greg McRandal Newbie

      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