Issue

• What is idle-timeout-minutes in datasource configuration ?
• Why is the connection not removed after idle-timeout-minutes ?
• Why is DestroyedCount always 0 for a data source which has not set max-pool-size and min-pool-size ?
• What is use of idle-timeout-minutes in datasource?
• We are relying on idle-timeout-minutes to flush idle connections and get below errors:

IO Error: End of TNS data channel; nested exception is java.sql.SQLRecoverableException: IO Error: End of TNS data channel
...
Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connection

• How to set idle timeout in a data source?
• What is the meaning of the following TRACE event?

<TIMESTAMP> TRACE [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (IdleRemover) Destroying timedout connection org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3b729fa1[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@624e2184 connection handles=0 lastUse=1388075895091 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@42b996d7 pool internal context=SemaphoreArrayListManagedConnectionPool@3a6f01bf[pool=<POOL NAME>]

• want to know when the connections would drop to 0, is it when the idle timeout kicks in ?