5.29 JDBC Connection Pool Settings tab

Tab components

List of tab items

The JDBC Connection Pool Settings tab displays the following dynamic item:

Sub title

Displays the name of the selected JDBC connection pool.

The JDBC Connection Pool Settings tab displays the following Connection pool Settings items in a sequence:

Initial and Minimum Pool Size spin box

Specify the initial and minimum pool size for the selected JDBC connection pool. The unit of this display item is Connections. By default, the value already specified for the selected JDBC connection pool is displayed.

• Minimum value: 0 (It is recommended that you do not specify values less than 5.)
• Maximum value: 2147483647

Maximum Pool Size spin box

Specify the maximum pool size for the selected JDBC connection pool. The unit of this display item is Connections. By default, the value already specified for the selected JDBC connection pool is displayed.

• Minimum value: 1 (It is recommended that you do not specify values less than 5.)
• Maximum value: 2147483647

Pool Resize Quantity spin box

Specify the pool resize quantity for the selected JDBC connection pool. The unit of this display item is Connections. By default, the value already specified for the selected JDBC connection pool is displayed.

• Minimum value: 1 (It is recommended that you do not specify values less than 5.)
• Maximum value: 2147483647

The minimum value in CUI specification is 0. However, if 0 is specified in this spin box, then the connection pool creation fails. As the CUI does not behave as per its specification, to avoid the failure condition, the minimum value specified in Administration Console is 1.

Idle Timeout spin box

Specify the idle timeout for the selected JDBC connection pool. The unit of this display item is seconds. By default, the value already specified for the selected JDBC connection pool is displayed.

• Minimum value: 0
• Maximum value: 2147483647

Max Wait Time spin box

Specify the maximum wait time for the selected JDBC connection pool. The unit of this display item is milliseconds. By default, the value already specified for the selected JDBC connection pool is displayed.

• Minimum value: 0
• Maximum value: 2147483647

The JDBC Connection Pool Settings tab displays the following action items:

Ping Connection Pool button

To confirm whether a connection test performed on the selected JDBC connection pool has succeeded or failed, click the Ping Connection Pool button to display the Connection Test dialog box.

Apply button

To apply and confirm the values specified in the Initial and Minimum Pool Size, Maximum Pool Size, Pool Resize Quantity, Idle Timeout, and the Max Wait Time spin boxes (for the selected JDBC connection pool), click the Apply button to display the Apply Changes dialog box, and then click the OK button. If an invalid value is specified, then an unknown error might occur. In such a case, you are required to correct the specified value.