0 Replies Latest reply on Apr 21, 2006 12:09 PM by anny_lut

    Connection to Oracle9i cluster

    anny_lut Newbie

      We have jboss321
      connection pool configuration in oracle-ds.xml to Oracle9iAS cluster

      <datasources>
       <local-tx-datasource>
       <jndi-name>BARSDB_ORACLE</jndi-name>
       <connection-url>jdbc:oracle:thin:@
       (description=(address_LIST=
       (LOAD_BALANCE=ON)
       (FAILOVER=ON)
       (address=(host=10.109.1.11)(protocol=tcp)(port=1521))
       (address=(host=10.109.1.12)(protocol=tcp)(port=1521)))
       (connect_data=(SERVICE_NAME=ORA_SID)))
       </connection-url>
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>USER</user-name>
       <password>PASSWD</password>
       <min-pool-size>10</min-pool-size>
       <max-pool-size>25</max-pool-size>
       <exception-sorter-class-name>org.jboss.resource.adapter.
       jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       </local-tx-datasource>
      </datasources>
      


      When our connection get "max connections per one node"
      it switched to another node, but in jboss connection pool this connection became dead.
      And as result we get such error:

      org.jboss.util.NestedSQLException: No ManagedConnections Available!; - nested throwable: (javax.resource.ResourceException: No ManagedConnections Available!)
      org.jboss.util.NestedSQLException: No ManagedConnections Available!; - nested throwable: (javax.resource.ResourceException: No ManagedConnections Available!)
       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
       at bars.kltoss.server.SvrPhase.getLocalDB(SvrPhase.java:165)
      


      Where can I read about jboss's connection pool to cluster. How I can correct my oracle-ds.xml
      for proper work with oracle cluster