Glassfish Server Getting Stale and Closed JDBC Connections with JDBC Connection Validation Enabled (Doc ID 1279829.1)

Symptoms

When an application requests a JDBC connection from the connection pool,  the connection returned may not be usable and throws the following exceptions:

This problem occurs even if the pool is configured with a valid connection validation method.

Changes

This problem can occur when the connection pool is configured to use the "associate-with-thread" option, and the back end database is restarted, even when the pool is configured with an effective database connection validation method.

Cause

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