A JDBC resource (data source) provides applications with a means of connecting to a database.
Before creating a JDBC resource, first create a JDBC connection pool. See To create a JDBC connection pool.
In the tree component, expand the Resources node.
Under Resources, expand the JDBC node.
Under JDBC, select the JDBC Resources node.
On the JDBC Resources page, click New.
On the Create JDBC Resource page, specify the resource’s settings:
In the JNDI Name field, type a unique name.
By convention, the name begins with the jdbc/ string. For example: jdbc/payrolldb. Don’t forget the forward slash.
From the Pool Name combo box, choose the connection pool to be associated with the new JDBC resource.
If you want the resource to be unavailable, deselect the Enabled checkbox.
By default, the resource is available (enabled) as soon as it is created.
In the Description field, type a short description of the resource.
In the Targets section, specify the targets (clusters and standalone server instances) on which the resource is available.
Select the desired target on the left, and click Add to add it to the list of selected targets.
Click OK.
create-jdbc-resource
In the tree component, expand the Resources node.
Under Resources, expand the JDBC node.
Under JDBC, expand the JDBC Resources node.
Select the node for the JDBC resource to be edited.
On the Edit JDBC Resource page, it is possible to perform these tasks:
From the Pool Name combo box, select a different connection pool.
In the Description field, change the short description of the resource.
Select or deselect the checkbox to enable or disable the resource.
Select the Targets tab to change the targets (clusters and standalone server instances) on which the resource is available.
Select the checkbox for an existing target in the list, then click Enable to enable the resource for that target or Disable to disable the resource for that target.
Click Manage Targets to add or remove targets to the list. In the Manage Targets page, select the desired target in the Available list on the left, and click Add to add it to the list of selected targets. Click Remove to remove a target from the Selected list.
Click OK to save the changes to the available targets.
Click Save to apply the edits.
In the tree component, expand the Resources node.
Under Resources, expand the JDBC node.
Under JDBC, select the Connection Pools node.
On the Connection Pools page, select the checkbox for the pool to be deleted.
Click Delete.