Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

Configure connection harvesting for a connection pool

You can specify a number of reserved connections to be released when a data source reaches a specified number of available connections. Harvesting helps to ensure that a specified number of connections are always available in the pool and improves performance by minimizing connecton initialization. For more information, see Configuring JDBC Data Sources.

To enable connection harvesting:

  1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
  2. In the Domain Structure tree, expand Services, then select Data Sources.
  3. On the Summary of Data Sources page, click the data source name.
  4. Select the Configuration: Connection Pool tab.
  5. Scroll down and click Advanced to show the advanced connection pool options.
  6. Configure the following attributes:

    Note: Connection harvesting is disabled by default. Setting the Connection Harvest Trigger Count to the value of -1 is used to disable connection harvesting.

    • Connection Harvest Trigger Count - Specifies the threshold value used to trigger harvesting. For example, if this value is set to 10, connection harvesting begins when the number of available connections in the data source drops to 10.
    • Connection Harvest Max Count - Specifies how many connections should be returned during harvesting.
  7. Click Save.
  8. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
    Not all changes take effect immediately—some require a restart (see Use the Change Center).

Back to Top