5.27 Create New JDBC Connection Pool dialog box
Use the Create New JDBC Connection Pool dialog box to create a new JDBC connection pool by performing operations such as using the default connection pool settings, editing the connection pool settings, adding the additional properties, deleting the selected additional properties, and editing the default additional properties. You can perform any or all of the operations to create a new JDBC connection pool.
Dialog box components
List of dialog box items
The Create New JDBC Connection Pool dialog box displays the following Basic Information items in a sequence:
- Name text box
-
Specify the name of the JDBC connection pool to be created. This is a mandatory item.
- Resource Type list box
-
Select the desired resource type from the Resource Type list box. You can select any one of the following resource types:
- java.sql.Driver
- javax.sql.ConnectionPoolDataSource
- javax.sql.DataSource
- javax.sql.XADataSource
By default, java.sql.Driver is selected as the resource type.
- Driver Classname text box
-
If "java.sql.Driver" is selected as a resource type in the Resource Type list box, then the Driver Classname text box is enabled. If this text box is enabled, then you can specify the fully qualified driver class name. By default, this text box is blank. This display item is mandatory only when it is enabled.
- Datasources Classname text box
-
Displays either a blank text box or a fully qualified datasource class name as a sample for editing the text. If "java.sql.Driver" is selected as a resource type in the Resource Type list box, then the Datasources Classname text box is disabled. This display item is mandatory only when it is enabled.
- Description text box
-
Specify the description for the JDBC connection pool which is being created. By default, this text box is blank.
The Create New Connection Pool dialog box 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 JDBC connection pool, which is being created. The unit of this display item is Connections.
- Default value: 24
- 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 JDBC connection pool, which is being created. The unit of this display item is Connections.
- Default value: 24
- 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 JDBC connection pool, which is being created. The unit of this display item is Connections.
- Default value: 2
- 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 JDBC connection pool, which is being created. The unit of this display item is seconds.
- Default value: 300
- Minimum value: 0
- Maximum value: 2147483647
- Max Wait Time spin box
-
Specify the maximum wait time for the JDBC connection pool, which is being created. The unit of this display item is milliseconds.
- Default value: 60000
- Minimum value: 0
- Maximum value: 2147483647
The Create New JDBC Connection Pool dialog box displays the following Additional Properties items in a tabular format:
S. No |
Display item |
Description |
---|---|---|
1 |
Property Selector |
Displays a header check box and check boxes to select or clear the properties listed in the Name column. If the header check box of the Property Selector column is selected or cleared, then all the check boxes of the Property Selector column are selected or cleared respectively. |
2 |
Name |
Displays a list of pre-defined property names depending on the resource type selected in the Resource Type list box and the new properties (if any), which are added using the Add button. Click the desired property name to edit the name of the property. By default, this column is sorted in ascending order. |
3 |
Value |
Displays a blank value for the pre-defined list of the property names in the Name column and for the new property values (if any), which are added using the Add button. Click the desired property value to edit the value of the property. This column can be sorted. |
4 |
Description |
Displays a blank description for the properties listed in the Name column. Click the desired property description to edit the description of the property. This column can be sorted. |
The Create New JDBC Connection Pool dialog box displays the following action items:
- Add button
-
Enables you to add additional properties to the newly created JDBC connection pool. To create a new property row with default values, click the Add button. The default values applied to the Name, Value, and Description columns are "New Property Name", "New Property Value", and blank description respectively. You can edit the values specified in these columns.
- Delete button
-
To delete the selected additional properties using the Property Selector column, click the Delete button. If no additional properties are selected in the Property Selector column, then this button is disabled.
- OK button
-
To create a JDBC connection pool with the name specified in the Name text box, click the OK button. If all the mandatory items are specified, then this button is enabled.
- Cancel button
-
To close the Create New JDBC Resource dialog box without creating a new JDBC resource, click the Cancel button.