To Create a JDBC Resource

A Java DataBase Connectivity (JDBC) resource (data source) provides applications with the means of connecting to a database.

Before You Begin

To create a JDBC resource, you must first create a JDBC connection pool. See To Create a JDBC Connection Pool.

  1. In the navigation tree, expand the Resources node.
  2. Under the Resources node, expand the JDBC node.
  3. Under the JDBC node, select the JDBC Resources node.

    The JDBC Resources page opens.

  4. On the JDBC Resources page, click New.

    The New JDBC Resource page opens.

  5. In the JNDI Name field, type a unique resource name.

    The J.N.D.I. name organizes and locates components within a distributed computing environment similarly to the way that card catalogs organize and represent locations of books in a library. Consequently, the J.N.D.I. name becomes an important method of accessing the JDBC resource. By convention, the name begins with the jdbc/ string, for example, jdbc/payrolldb. Don’t forget the forward slash.

    Name must contain only alphanumeric, underscore, dash, or dot characters.

  6. From the Pool Name drop-down list, select a connection pool to be associated with the new JDBC resource.
  7. In the Description field, type a short description of the new JDBC resource.
  8. Deselect the Enabled checkbox to disable the resource so that it is unavailable.

    By default, the resource is available (enabled) when it is created.

  9. Click OK.
See Also