Re: Pooled connection closing sockets
Posted by: Mark Matthews
Date: December 07, 2016 11:50AM


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 Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools

Options: ReplyQuote

Written By
Re: Pooled connection closing sockets
December 07, 2016 11:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.