All Downloads are FREE. Search and download functionalities are using the official Maven repository.

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

There is a newer version: 8.0.0-JDK17-M7
Show newest version


Edit Connector Connection Pool Advanced Attributes

Use the Edit Connector Connection Pool Advanced Attributes page to modify the advanced settings for a connector connection pool.

The Edit Connector 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.

Validate At Most Once

Specifies the time interval in seconds between successive requests to validate a connection at most once. Default value is 0, which means the attribute is not enabled.

Leak Timeout

The amount of time, in seconds, to trace connection leaks in a connection pool. A value of 0 indicates that connection leak tracing is disabled. The default value is 0.

Leak Reclaim

If this option is selected, leaked connections will be restored to the pool after leak connection 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 indicates that no attempts will be made to create the connection again. The default value is 0.

Retry Interval

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

Pooling

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

Lazy Association

If this option is selected, connections will be lazily associated when an operation is performed on them. The 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 selected, a resource is enlisted in the transaction only when it is actually used in a method. This option is disabled by default.

Associate with Thread

If this option is selected, a connection is associated with a thread. When the same thread is in need of a connection, it can reuse the connection already associated with it, thereby not incurring the overhead of getting a connection from the pool. This option is disabled by default.

Match Connections

If this option is selected, connection matching is enabled for the pool. This option can be disabled if you know that the connections in the pool will always be homogeneous and hence a connection picked from the pool need not be matched by the resource adapter. This option is enabled by default.

Match Connection Usage

The number of times a connection should be reused by the pool. Once a connection is reused for the specified number of times, it will be closed. A value of 0 indicates that this attribute is not enabled. The default value is 0.

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




© 2015 - 2024 Weber Informatics LLC | Privacy Policy