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

[Figure]

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.

To Page Top