Configuring Table Based Connection Pool Validation in Oracle Glassfish Server 3.0.1 (Doc ID 1137470.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle GlassFish Server - Version 2.1 to 3.0 [Release 2.1 to 3.0]
Information in this document applies to any platform.
***Checked for relevance on 24-Feb-2012***


Goal

In Oracle GlassFish Application Server 3.0.1, the Administration Console does not provide a way of specifying the table to use with Table Based Connection Validation.  This article details how to workaround this problem.

As you can see, highlighted in the following image, from the JDBC Connection Pool Advanced Attributes Tab, there is a drop down list for choosing the table name: 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms