activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pawel Tucholski <pawel.tuchol...@gmail.com>
Subject DB connection pool
Date Thu, 07 Dec 2006 16:32:57 GMT

I've noticed that, when using org.apache.commons.dbcp.BasicDataSource, number
of connections to database can be much higher than max number of
connections.  I found that the root cause of this bug is in commons-dbcp -
http://issues.apache.org/jira/browse/DBCP-23. This bug causes that
connection is never passivated properly as close on connection involves
close on prepared statements and close on prepared statements throws
SQLException("Already closed").
Some workaround for this problem is disabling of pooling of prepared
statements.

Pawel Tucholski
-- 
View this message in context: http://www.nabble.com/DB-connection-pool-tf2775515.html#a7742611
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message