My app running under JBoss 4.0.4 uses Oracle DB configured with the following DS file:
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?