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. 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 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user