2.1 Set Database Connection dialog box

Dialog box components

List of dialog box items

The Set Database Connection dialog box displays the following Pool items in a sequence:

Pool Name text box

Specify the name of the JDBC Connection Pool. By default, this text box displays value default_pool. This is a mandatory item.

DB Type list box

Select the type of the database from the DB Type list box. You can select any one of the following database types:

• HiRDB
• Oracle
• SQLServer

HiRDB or SQLServer is not supported. If you select HiRDB or SQLServer as the DB type, then further operations cannot be guaranteed.By default, *Please Select* is selected. This is a mandatory item and you must select an appropriate database type.

DB Name text box

Specify the name of the DB. If you select Oracle, then the DB Name text box displays the default value "sid" and is editable. This is a mandatory item only when Oracle is selected in the DB Type list box.

Host text box

Specify the name of the Host. By default, this text box displays the value localhost. This is a mandatory item.

Port spin box

Specify the desired port number. You can specify a value within the range of 2 to 65535.

• Minimum value: 2
• Maximum value: 65535

If *Please Select* is selected in the DB Type list box, then the Port spin box is disabled and is not mandatory. The Port spin box displays a value (65536), which is not in range. The Port spin box displays the default port number based on the selected database type in the DB Type list box. The default port number for:

• Oracle: 1521

If you specify an invalid value, then the Port spin box displays the default value of the selected database type, after the focus is out of the spin box.

User ID text box

Specify the user ID, which is required to connect to the specified database.

Password text box

Specify the password, which is required to connect to the specified database. The password characters are displayed as an asterisk (*).

The Set Database Connection dialog box displays the following Resource item:

JNDI Name text box

Specify the JNDI name. By default, this text box displays the value default_resource. This is a mandatory item.

The Set Database Connection dialog box displays the following Target items in a tabular format:

S. No.	Display Item	Description
1	Target Server Selector	Displays a check box for each server name listed in the Name column. If the header check box of the Target Server Selector column is selected or cleared, then all the check boxes of the Target Server Selector column are selected or cleared respectively.
2	Name	Displays a list of all the available clusters, non-clustered Java EE servers, and the Domain Administration Server (DAS). By default, this column is sorted in ascending order.

The Set Database Connection dialog box displays the following action items:

OK button

To create a database connection and set it on the specific target(s), click the OK button. If you specify all the mandatory items in the Set Database Connection dialog box, then this button is enabled.

Cancel button

To close the Set Database Connection dialog box without creating a database connection, click the Cancel button.