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


      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:

       <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
       <!-- The maximum connections in a pool/sub-pool -->
       <!-- 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 -->
       <!-- Checks the Oracle error codes and messages for fatal errors -->
       <!-- sql to call when connection is created
       <new-connection-sql>some arbitrary sql</new-connection-sql>

      If it helps this file works perfectly in JBoss 4.0.3

      Thanks for your help