The connection pool configuration enables efficient use of database connection, and improves application performance and scalability.

Procedure

  1. Toggle Conncetion Pooling to ON, and provide the following details:
    1. Provide a list of space separated authentication types of connections that may be pooled in Connection Pooling Authentication.
    2. Provide a string that indicates the level of debug output in Connection Pool Debug Level.
    3. Provide an integer number of connections per connection identity in Connection Pool Initial Size.
    4. Provide an integer that represents the maximum number of connections per connection identity that can be maintained concurrently in Connection Pool Maximum Size.
    5. Provide an integer that represents the maximum number of connections per connection identity that can be maintained concurrently in Connection Pool Preferred Size.
    6. Provide a list of space separated protocol types of connections that may be pooled in Connection Pool Protocol.
    7. Provide an integer that represents the number milliseconds that an ideal connection may remain in the pool in Connection Pool Timeout .
    8. Click Next.

What to do next

Add Kerberos authentication settings. This is an optional step.