Hello all,
I'm getting the following exception, using commons-dbcp-1.4.
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1144)
~[commons-pool-1.5.5.jar:1.5.5]
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
~[commons-dbcp-1.4.jar:1.4]
... 62 common frames omitted
Connections are managed by spring. These are the dbcp config parameters:
poolPreparedStatements=true
defaultAutoCommit=false
driverClassName=oracle.jdbc.driver.OracleDriver
validationQuery=select 0 from dual
initialSize=1
maxActive=15
maxIdle=15
maxWait=60000
removeAbandoned=false
removeAbandonedTimeout=300
On the database (oracle) I see no active connections when the problem occurs,
and sometimes a few inactive connections (5 connections).
I got an heap dump, and found that the ConnectionPool object (instance of
org.apache.commons.pool.impl.GenericObjectPool) numActive variable value is 15,
so I understand that the connection pool thinks that there are 15 active
connections.
I can't understand why this happen, because on the database there aren't so
many connections.
On the heap dump, another thing is strange: the ConnectionPool object variable
"pool", which as far I understand is the list of the connections managed by the
pool, contains no element!
Bye,
Andrea
Andrea Bosio
Manager
Technology Reply
Via Cardinal Massaia, 71
10147 - Torino - ITALY
phone: +39 011 29100
mobile: +39 348 9504513
a.bo...@reply.it
www.reply.it
[Technology Reply]
________________________________
--
The information transmitted is intended for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in
reliance upon, this information by persons or entities other than the intended
recipient is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.
