2 Replies Latest reply on Jun 17, 2008 4:31 AM by Sivaprakash Venkatasamy

    Connection pool not releasing idle connections

    Y E Newbie

      Hello,
      My app running under JBoss 4.0.4 uses Oracle DB configured with the following DS file:

      
      <datasources>
       <local-tx-datasource>
       <jndi-name>jdbc/mydb</jndi-name>
       <connection-url>jdbc:oracle:thin:@111.222.333.444:1521:oradb</connection-url>
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>user</user-name>
       <password>pass</password>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       <metadata>
       <type-mapping>Oracle9i</type-mapping>
       </metadata>
       <min-pool-size>3</min-pool-size>
       <max-pool-size>10</max-pool-size>
       <idle-timeout-minutes>1</idle-timeout-minutes>
       </local-tx-datasource>
      </datasources>
      


      I was expecting every minute( or whatever interval is given in idle-timeout-minutes) a process that removes the idle connections to be run.
      This doesn't happen. I run a test that reached the maximum number of connections. I then started monitoring the connections, but none of the idle connections were removed.
      I checked my code and every connection was closed after an operation.
      Is there anything wrong with my configuration? What could be keeping these connections open?
      Thanks.