MySQL Forums
Forum List  »  Connector/JDBC and Java

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

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

Options: ReplyQuote


Subject
Written By
Posted
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.