hi,
I have 3 database and i would like to get the connection randomly from these 3 database. My problem is sometimes i can get the connection and sometimes i can't get. Can anyone tell me what is wrong with the datasource configuration? I am using oracle version 9
<local-tx-datasource>
<jndi-name>ds</jndi-name>
<connection-url>jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.2)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.3)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=ds)))
</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>user</user-name>
password <blocking-timeout-millis>25000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
Besides that i would like to extend the connecting time to 30 minutes. Where should i modify the connection time? Is it at the <idle-timeout-minutes>30</idle-timeout-minutes>?
Where to set the maximum connection?
Thanks in advance