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

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

There is a newer version: 3.2-b03
Show newest version



To Edit Connector Connection Pool Advanced Attributes

  1. In the navigation tree, expand the Resources node.
  2. Expand the Connectors node.
  3. Under the Connectors node, select the Connector Connection Pools node.

    The Connector Connection Pools page opens.

  4. 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.

  5. On the Edit Connector Connection Pool page, click the Advanced tab.

    The Edit Advanced Attributes page opens.

  6. 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.

  7. 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.

  8. 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.

  9. 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.

  10. 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.

  11. 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.

  12. 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.

  13. 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.

  14. 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.

  15. 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.

  16. Click Save.

    Tip - To return to the default settings, click the Load Defaults button, then click Save.


See Also




© 2015 - 2024 Weber Informatics LLC | Privacy Policy