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***


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: 

However, the list is empty and there is no way of adding a table name from the administration web console.  In previous versions of the Application Server the console used a text field to allow the table name to be specified.


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