Re: Pooled connection closing sockets

[Mark Matthews]

Hi,

Contrary to popular belief, an implementation of ConnectionPoolDataSource is *not* a connection pool. It is a DataSource of PooledConnections, which are horribly named, it should've been named "PoolableConnection".

If your code is expecting connection-pool-like behavior from PooledConnections vended from a ConnectionPoolDataSource implementation it won't work correctly.

The PooledConnection interface is intended to be used by a connection pool manager to hand out logical connections (which may or may not be the same physical connection). It does no pooling of it's own. Closing a PooledConnection will in most JDBC implementations close the underlying physical connection.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html