Validation Query
Type
Constant String
Since
2.2
Description
This property can hold any SQL-statement which will be executed every time when a connection is taken from the connection pool. If the statement fails (e.g. because the database-server was restarted meanwhile and the connection is no longer valid), the connection will be rebuild.
By default, this property is empty and no validation will be performed. This property is only used when defining a connection manually using the JDBC-Driver and URL properties. If a datasource defined by the webserver (using the "Datasource" property) is used, it has to define its own validation.
Examples
Validation Query = "SELECT 1"
Validation Query = "SELECT COUNT(*) FROM PRODUCTS"
