4.21 JDBC Resource pane (Management tab)

Use the JDBC Resource pane to view all the available JDBC resources and information of target(s) associated with the resource. You can also enable or disable the resource on the target(s).

Pane components

[Figure]

List of pane items

The JDBC Resource pane displays the following dynamic item:

JDBC Resource count: Displays (within parentheses) the total number of available resources.

The JDBC Resource pane displays the following items in a tabular format:

S. No	Display item	Description
1	JNDI Name	Displays the JNDI name (as a link) of the resource(s). Click this link to display the details of the corresponding resource in the JDBC Resource Target tab. By default, this column is sorted in ascending order.
2	Description	Displays the description of the resource(s) listed in the JNDI Name column. If the description of a resource is not available, then this display item is blank. This column can be sorted.
3	Connection Pool	Displays the name of the connection pool (along with a link button) associated with the resource(s) listed in the JNDI Name column. Click this link button to display the general information of the corresponding connection pool in the JDBC Connection Pool General tab (in the Configuration tab). This column can be sorted.
4	Target	Displays the target information (along with a link button) of the resource(s). Click this link button to display a list of target(s) associated with the resource in the JDBC Resource Target tab (in the Configuration tab). The display format of the target information is " Enabled on `count of targets on which resource is enabled` of `count of targets associated with the resource` Target(s)". This column can be sorted.
5	Enabled	Displays check boxes to enable or disable the resource(s) listed in the JNDI Name column. If a resource is created only on the DAS, then the corresponding check box is disabled and cleared. If a resource is enabled on at least one target, then the corresponding check box is selected. If a resource is disabled on any of its targets, then the corresponding check box is cleared. To enable a resource, select the corresponding Enabled check box to display the Enable JDBC Resource dialog box, and then click the OK button. To disable a resource, clear the corresponding Enabled check box to display the Disable JDBC Resource dialog box, and then click the OK button. This column can be sorted.

The JDBC Resource pane displays the following action items:

Enable All button: To enable all the resources, click the Enable All button to display the Enable JDBC Resource dialog box, and then click the OK button.
Disable All button: To disable all the resources, click the Disable All button to display the Disable JDBC Resource dialog box, and then click the OK button.