en.help.task-connectorconnectionpooladvance.html Maven / Gradle / Ivy
Show all versions of console-jca-plugin Show documentation
To Edit Connector Connection Pool Advanced Attributes
-
In the navigation tree, expand the Resources node.
-
Expand the Connectors node.
-
Under the Connectors node, select the Connector Connection Pools node.
The Connector Connection Pools page opens.
-
On the Connector Connection Pools page, click the name of the connector connection pool that you are editing.
The Edit Connector Connection Pool page opens.
-
On the Edit Connector Connection Pool page, click the Advanced tab.
The Edit Connector Connection Pool Advanced Attributes page opens.
-
In the Validate At Most Once field, type the amount of time, in seconds, after which a connection is validated 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.
-
In the Leak Timeout field, type 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.
-
Select the Leak Reclaim checkbox to enable leaked connections to be restored to the pool after leak connection tracing is complete.
This option is disabled by default.
-
In the Creation Retry Attempts field, type 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.
-
In the Retry Interval field, type 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.
-
Select the Pooling checkbox to enable connection pooling for the pool.
This option is enabled by default.
-
Select the Lazy Association checkbox to enable connections to 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.
-
Select the Lazy Connection Enlistment checkbox to enlist a resource to the transaction only when it is actually used in a method.
This option is disabled by default.
-
Select the Associate with Thread checkbox to associate a connection 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.
-
Select the Match Connections checkbox to enable connection matching for the pool.
Disable this option 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.
-
In the Match Connection Usage field, type 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.
-
Click Save.
Tip:
To return to the default settings, click the Load Defaults button, then click Save.
See Also
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Copyright © 2005, 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices