Configuring Table Based Connection Pool Validation in Oracle Glassfish Server 3.0.1
(Doc ID 1137470.1)
Last updated on JULY 06, 2020
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.
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