This content has been marked as final.
Show 1 reply
-
1. Re: oracle datasource configuration
lee_yuki2000 Jan 27, 2004 11:03 PM (in response to lee_yuki2000)"lee_yuki2000" wrote:
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
<datasources>
<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>password</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>
</datasources>
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>?
Thank you very much