0 Replies Latest reply on Feb 17, 2004 1:20 AM by lee_yuki2000

    Multiple connectiont to multiple database setting

    lee_yuki2000 Newbie

      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