My Oracle Support Banner

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: 



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.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

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