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.

To define JDBC Connection Pooling:

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 11-21 Connection Pools

   
   

   

   
   
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.