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

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

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


To Edit a Connector Connection Pool

  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. From the Resource Adapter drop-down list, select a different resource adapter.

  6. From the Connection Definition drop-down list, select the class name for the connection definition.

    The choices in the list depend on the resource adapter you selected. The connection definition identifies a resource adapter's connection-definition element in thera.xml file.

  7. Select the Ping Enabled checkbox to ping the connection pool during creation or reconfiguration to identify and warn of any erroneous values for its attributes.

    This option is disabled by default.

  8. In the Deployment Order field, type a number to specify the deployment order of the connector connection pool.

    Resources with a lower number are loaded first at server startup. The default value is 100.

  9. In the Description field, type a description of the connector connection pool.

  10. In the Initial and Minimum Pool Size field, specify the minimum number of connections in the connector connection pool.

    The default value is 8.

  11. In the Maximum Pool Size field, specify the maximum number of connections in the connector connection pool.

    The default value is 32.

  12. In the Pool Resize Quantity field, specify the number of connections to be removed when pool idle timeout expires.

    The default value is 2.

  13. In the Idle Timeout field, specify the maximum time in seconds that a connection can remain idle in the pool.

    The default value is 300.

  14. In the Max Wait Time field, specify the amount of time the application requesting a connection will wait before getting a connection timeout.

    The default value is 60000.

  15. Select the Connection Validation Required checkbox to enable connection validation.

    If the Required checkbox is selected, connections are validated before being given to the application. If a resource's validation fails, it is destroyed, and a new resource is created and returned. This option is disabled by default.

  16. Select the On Any Failure checkbox so GlassFish Server will close all connections in the pool and reestablish them if a single connection fails.

    If you do not select the checkbox, individual connections will be reestablished only when they are used.

  17. From the Transaction Support drop-down list, select the type of transaction support for the connection pool.

    The chosen transaction support overrides the transaction support attribute in the resource adapter associated with this connection pool in a downward compatible way. In other words, it can support a lower transaction level than that specified in the resource adapter, or the same transaction level as that specified in resource adapter, but it cannot specify a higher level.

    The following options are available in the drop-down list:

    • NoTransaction: Indicates that the resource adapter does not support resource manager local or JTA transactions and does not implement XAResource or LocalTransaction interfaces.

    • LocalTransaction: Indicates that the resource adapter supports local transactions by implementing the LocalTransaction interface.

      Local transactions are managed internal to a resource manager and involve no external transaction managers.

    • XATransaction: Indicates that the resource adapter supports resource manager local and JTA transactions by implementing the LocalTransaction and XAResource interfaces.

      XA transactions are controlled and coordinated by a transaction manager external to a resource manager.

  18. Click the Flush button to flush all connections from the pool.

    Clicking the Flush button destroys any existing connections, recreates connections established for the pool, and restores the pool to its initial and minimum pool size.

  19. Click the Ping button to verify that the connection pool is usable.

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




© 2015 - 2024 Weber Informatics LLC | Privacy Policy