en.help.ref-jdbcconnpooladvanceattrtab.html Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of console-jdbc-plugin Show documentation
JDBC plugin bundle for GlassFish Admin Console
There is a newer version: 8.0.0-JDK17-M7




Edit Connection Pool Advanced Attributes

Use the Edit Connection Pool Advanced Attributes page to specify attributes that help diagnose connection leaks and improve ease-of-use.
The Edit Connection Pool Advanced Attributes page contains the following options.

Load Defaults

Button to restore settings that have default values to their default values. Settings that do not have default values are not changed.

Pool Name

The name of the connection pool. The name is a read-only field. You can only specify the connection pool name when you create a new JDBC connection pool.

Statement Timeout

The length of time, in seconds, after which abnormally long running queries will be terminated. GlassFish Server will set QueryTimeout on the statements created. A value of -1 means that the option is disabled. The default value is -1.

Statement Cache Size

The number of statements to be cached using the LRU (Least Recently Used) caching mechanism. A value of 0 disables statement caching. The default value is 0.

Init SQL

An SQL string to be executed whenever a connection is created (not reused) in the pool. Execution of this string initializes the state of the connection.

SQL Trace Listeners

A comma-separated list of listener implementation class names, which specifies that SQL statements executed by applications will be traced. 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.

Wrap JDBC Objects

If this option is enabled, applications will get wrapped JDBC objects for Statement, PreparedStatement, CallableStatement, ResultSet, DatabaseMetaData. This option is enabled by default.

Pooling

Enables connection pooling for the pool. This option is enabled by default.

Validate At Most Once

Specifies the time interval in seconds between successive requests to validate a connection at most once. Setting this attribute to an appropriate value minimizes the number of validation requests by a connection. Default value is 0, which means that the attribute is not enabled.

Connection Leak Timeout

The amount of time, in seconds, to trace connection leaks in a connection pool. 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. A value of 0 means that connection leak tracing is disabled. The default value is 0.
Use this field along with Leak Reclaim to avoid potential connection leaks from the application.

Connection Leak Reclaim

If this option is enabled, leaked connections are restored to the pool after leak connection tracing is complete. This option is disabled by default.

Statement Leak Timeout

The amount of time, in seconds, to trace statement leaks in a connection pool. Use this field to detect potential statement leaks by the application. A statement 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. A value of 0 means that statement leak tracing is disabled. The default value is 0.
Use this field along with Statement Leak Reclaim to avoid potential connection leaks from the application.

Statement Leak Reclaim

If this option is enabled, leaked statements are restored to the pool after leak statement tracing is complete. This option is disabled by default.

Creation Retry Attempts

The number of attempts that will be made if there is a failure in creating a new connection. A value of 0 means that no attempts will be made to create the connection again. The default value is 0.

Retry Interval

The interval of time, in seconds, between two attempts to create a connection. The default value is 10. This attribute is used only if the value of Creation Retry Attempts is greater than 0.

Lazy Association

If this option is enabled, a physical connection is associated with a logical collection only when the connection is used. Connections are disassociated when the transaction is completed and a component method ends, which helps reuse of the physical connections. This option is disabled by default.

Lazy Connection Enlistment

If this option is enabled, a resource is enlisted to the transaction only when it is actually used in a method. This option is disabled by default.

Associate with Thread

If this option is enabled, an association is made between a connection and a thread such that when the same thread is in need of a connection, it can reuse the connection already associated with that thread, thereby not incurring the overhead of getting a connection from the pool. This option is disabled by default.

Match Connections

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 safely be disabled if the administrator knows that the connections in the pool will always be homogeneous and hence a connection picked from the pool does not need to be matched by the resource adapter. This option is disabled by default.

Max Connection Usage

The number of times that a connection should be reused by the pool. 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. A value of 0 means that this attribute is disabled. The default value is 0.

Connection Validation

If this option is enabled, connection validation is required, allowing the server to reconnect in case of failure.

Validation Method

GlassFish Server can validate database connections in the following ways.

auto-commit and metadata

GlassFish Server validates a connection by calling the con.getAutoCommit or con.getMetaData method.


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.




custom-validation

GlassFish Server uses a user-defined validation mechanism specified by the custom implementation class in the Validation Classname field.

table

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.



Table Name

Name of the database table for validation. This field is applicable only if the Validation Method was set to table. You can either select the name from the drop-down list or type it.

Validation Class Name

The custom validation implementation class name. This field is applicable only if the Validation Method was set to custom-validation. The class name provided must be accessible to GlassFish Server. The specified class must implement the org.glassfish.api.jdbc.ConnectionValidation interface. You can either select the name from the drop-down list or type it.

On Any Failure

If this option is enabled, the GlassFish Server closes all connections in the pool and reestablishes them when any connection fails. If the option is disabled, individual connections are reestablished only when they are used. This option is disabled by default.

Allow Non Component Callers

If this option is enabled, the pool can be used by non-component callers such as servlet filters and third-party persistence managers. 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.



Related Tasks


To Set Up Database Access


To Integrate a JDBC Driver


To Create a JDBC Connection Pool


To Edit JDBC Connection Pool General Settings


To Verify Connection Pool Settings


To Edit JDBC Connection Pool Advanced Attributes


To Edit JDBC Connection Pool Properties


To Delete a JDBC Connection Pool



Related asadmin Commands


add-resources(1)


create-jdbc-connection-pool(1)


delete-jdbc-connection-pool(1)


flush-connection-pool(1)


list-jdbc-connection-pools(1)


ping-connection-pool(1)


start-database(1)


stop-database(1)




Copyright © 2005, 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices