[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Connection pool not releasing idle connections

bossy do-not-reply at jboss.com
Fri Jan 11 07:33:33 EST 2008

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?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4119018#4119018

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4119018

More information about the jboss-user mailing list