1 Reply Latest reply on Jan 27, 2004 11:03 PM by lee_yuki2000

    oracle datasource configuration

    lee_yuki2000 Newbie

       

      "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=oradb)))
      </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



        • 1. Re: oracle datasource configuration
          lee_yuki2000 Newbie

           

          "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