How To Close a Physical Connection in a Connection Pool ? (Doc ID 452915.1)

Last updated on AUGUST 09, 2023

Applies to:

Goal

A JDBC  application uses a connection pool.  Occasionally a connection might be altered in such a way that it should not be placed back on the pool for general use.

For example a connection has opened DB links that might become stale by the time the connection is re-used.

The default call for closing the connection is:  connection.close()

Since the connection is pooled,  this merely places the connection back in the pool for re-use, which in this case is not suitable.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.