en.help.task-connectorconnectionpooladvance.html Maven / Gradle / Ivy
Show all versions of console-jca-plugin-help
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 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.
A value of 0 indicates that connection validation is not enabled. The default value
is 0.
- 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 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. This is useful, for instance, to avoid statement leaks. 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