2 Replies Latest reply on May 5, 2005 3:45 AM by Angelo Immediata

    Connection TimeOut

    Angelo Immediata Newbie

      Hi all; i ahve this oracle-ds.xml:


      <local-tx-datasource>
      <jndi-name>anagrafe</jndi-name>
      <connection-url>jdbc:oracle:thin:@xxx.xxx.xx.xxx:1521:test</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>root</user-name>
      root
      <min-pool-size>10</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <blocking-timeout-millis>10000</blocking-timeout-millis>
      <idle-timeout-minutes>-1</idle-timeout-minutes>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>



      Well i have seen that if the Oracle DB instance is shutted down and after a little time it is restarted, JBoss loses the connection and it doesn't reconnect to the DB until i restart JBoss... How can i do for evitng this thing?
      Thanks