The Connection Pools page opens.
The Edit Connection Pool page opens.
The Edit Connection Pool Advanced Attributes page opens.
GlassFish Server will set QueryTimeout on the statements created. Set the value to -1 to disable this option. The default value is -1.
To disable statement caching, specify a value of 0. The default value is 0.
Execution of this string initializes the state of the connection.
The listener classes must implement the org.glassfish.api.jdbc.SQLTraceListener interface. Use of listeners enables easy filtering of log messages for the SQL statements and helps administrators analyze the statements.
This option is enabled by default.
This option is enabled by default.
This will help reduce the number of validation requests by a connection. The default value is 0.
Use this field to detect potential connection leaks by the application. A connection that is not returned back to the pool by the application within the specified period is assumed to be potentially leaking, and a stack trace of the caller is logged. Set the value to 0 to disable connection leak tracing. The default value is 0.
Use this field along with Leak Reclaim to avoid potential connection leaks from the application.
This option is disabled by default.
Set the value to 0 to make no attempts to create the connection again. The default value is 0.
The default value is 10. This attribute is used only if the value of Creation Retry Attempts is greater than 0.
Connections are disassociated when the transaction is completed and a component method ends, which helps reuse of the physical connections. If this option is disabled, a physical connection is associated with a logical connection even before it is used. This option is disabled by default.
This option is disabled by default.
When the same thread is in need of another connection, it can reuse the connection already associated with that thread, thereby not incurring the overhead of getting another connection from the pool. This option is disabled by default.
If this option is enabled, a connection that is selected from the pool should be matched with connections that have certain credentials. This option must be enabled if the connection pool is used by applications that have multiple user credentials. This option can be disabled if the administrator knows that the connections in the pool will always be homogeneous and therefore a connection picked from the pool does not need to be matched by the resource adapter. This option is disabled by default.
Once a connection is reused for the specified number of times, it will be closed. By limiting the number of times a connection can be reused, you can avoid statement leaks if an application does not close statements. Set the value to 0 disable this attribute. The default value is 0.
Connection validation allows the server to reconnect in case of failure.
The GlassFish Server can validate database connections in the following ways.
The GlassFish Servervalidates a connection by calling the con.getAutoCommit and con.getMetaData methods.
Note - Many JDBC drivers cache the results of these calls. As a result, using these calls might not always provide reliable validations. Check with the driver vendor to determine whether these calls are cached or not.
The GlassFish Server uses a user-defined validation mechanism specified by the custom implementation class in the Validation Classname field.
The application queries the database table that is specified. The table must exist and be accessible, but it does not require any rows. Do not use an existing table that has a large number of rows, or a table that is already frequently accessed.
The class name provided must be accessible to the GlassFish Server. The specified class must implement the org.glassfish.api.jdbc.ConnectionValidation interface.
If this option is disabled, individual connections are reestablished only when they are used. This option is disabled by default.
Connections obtained by non-component callers are not automatically closed at the end of a transaction by the container. They must be explicitly closed by the caller. This option is disabled by default.
Clicking the Flush button destroys any existing connections, recreates connections established for the pool, and restores the pool to its initial and minimum pool size.
Tip - To return to the default settings, click the Load Defaults button, then click Save.