Hello,
My app running under JBoss 4.0.4 uses Oracle DB configured with the following DS file:
|
|
| <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>
| pass
| <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
|
| <type-mapping>Oracle9i</type-mapping>
|
| <min-pool-size>3</min-pool-size>
| <max-pool-size>10</max-pool-size>
| <idle-timeout-minutes>1</idle-timeout-minutes>
| </local-tx-datasource>
|
|
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.
Enable to jca(org.jboss.resource) logs and explain the behavior through the logs .
We have not heard any issues about the abnormal behavior of the IdleTimeout behavior.