7.7.1.4 Define JDBC Connection Pooling

To define the JDBC connection pooling, ensure that you have created JDBC Provider and Data source to access the data from the database.
  1. Expand the Resources option in the LHS menu and click JDBC > Data sources option to display the Data sources window.
  2. Click the newly created Data Source $DATA_SOURCE$ and navigate to the path Data sources > GAFUSION DATA_SOURCE > Connection pools.

    Figure 7-30 Connection Pools


    Set the Connection timeout, Maximum connections, and Minimum connections. You can also define Reap time, Unused timeout, and Aged timeout as required.

  3. Set the following values:
    1. Connection timeout: 0
    2. Maximum connections: 100
    3. Minimum connections: 10
    You can also define Reap time, Unused timeout, and Aged timeout as required.