Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Performance Tuning Guide

- Previous: Isolation Level Settings
- Next: Connector Connection Pool Settings

#### Connection Validation Settings

The following settings determine whether and how the pool performs connection validation.

Connection Validation Required

  If true, the pool validates connections (checks to find out if they are usable) before providing them to an application.

  If possible, keep the default value, false. Requiring connection validation forces the server to apply the validation algorithm every time the pool returns a connection, which adds overhead to the latency of `getConnection()`. If the database connectivity is reliable, you can omit validation.

Validation Method

  Type of connection validation to perform. Must be one of:

  - auto-commit: attempt to perform an auto-commit on the connection.

  - metadata: attempt to get metadata from the connection.

  - table (performing a query on a specified table). Must also set Table Name. You may have to use this method if the JDBC driver caches calls to `setAutoCommit()` and `getMetaData()`.

Table Name

  Table name to query when Validation Method is “table.”

Close All Connections On Any Failure

  Whether to close all connections in the pool if a single validation check fails. The default is false. One attempt will be made to re-establish failed connections.

- Previous: Isolation Level Settings
- Next: Connector Connection Pool Settings

- © 2010, Oracle Corporation and/or its affiliates