JDBC Data Sources

 

Create a JDBC Data Source

1. Click to expand the JDBC node.

2. Click the Data Sources node. The Data Sources table displays in the right pane showing all the data sources defined in your domain.

3. Click the Create a New JDBC Data Source text link. A dialog displays in the right pane showing the tabs associated with configuring a new data source.

4. Enter values in the Name, JNDI Name, and Pool Name attribute fields.

5. Click Create to create a data source instance with the name you specified in the Name field. The new instance is added under the Data Sources node in the left pane.

Clone a JDBC Data Source

1. Click to expand the JDBC node.

2. Click the Data Sources node. The Data Sources table displays in the right pane showing all the data sources defined in your domain.

3. Click the Clone icon in the row of the data source you want to clone. A dialog displays in the right pane showing the tabs associated with cloning a data source.

4. Enter values in the Name, JNDI Name, and Pool Name attribute fields.

5. Click Create to create a data source instance with the name you specified in the Name field. The new instance is added under the Data Sources node in the left pane.

Delete a JDBC Data Source

1. Click to expand the JDBC node.

2. Click the Data Sources node. The Data Sources table displays in the right pane showing all the data sources defined in your domain.

3. Click the Delete icon in the row of the data source you want to delete. A dialog displays in the right pane asking you to confirm your deletion request.

4. Click Yes to delete the data source. The data source icon under the Data Sources node is deleted.

Monitor All Instances of a JDBC Data Source

1. Click to expand the JDBC node.

2. Click the Data Sources node in the left pane. The Data Sources table displays in the right pane showing all the data sources defined in the domain.

3. Click the Monitor All Instances icon in the row of the data source you want to monitor. A dialog displays in the right pane showing all instances of the data source deployed across the server domain.

Assign a JDBC Data Source

1. Click the instance node in the left pane under Data Sources for the source you want to assign. A dialog displays in the right pane showing the tabs associated with this instance.

2. Click the Targets tab.

3. Complete the following steps for the Servers, Groups, and Clusters tabs:

   1. Select one or more targets in the Available column that you want to assign to the data source.

   2. Click the mover control to move the targets you selected to the Chosen column.

   3. Click Apply to save your assignments.

Configuration

General

Target

Servers

Clusters

Notes

For more information about JDBC Data Sources, see the Administration Guide.