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
