Step 3: Create the JDBC Resources

A JDBC resource (also known as a data source) gives the master index application the ability to connect to the database. You need to create one for each connection pool created earlier.

To Create the JDBC Resources

Before You Begin

Create the JDBC connection pool, as described in Step 2: Create the JDBC Connection Pools.

1. In the left portion of the Admin Console, expand Resources, expand JDBC, and then select JDBC Resources.
2. On the Create JDBC Resource page, click New.
3. In the JNDI Name field, enter a unique name for the JDBC resource.

   The name must be in the form jdbc/application_nameDataSource, where application_name is the name of the master index application. For example, jdbc/PersonDataSource.

4. In the Pool Name field, enter the name of the first JDBC connection pool you created in Step 2: Create the JDBC Connection Pools.
5. (Optional) In the Description field, enter a brief description of the resource.
6. In the Status field, select the Enabled check box.
7. Click OK.
8. Repeat the above steps to create another JDBC resource for the sequence manager using these guidelines:

   • For the connection pool, select the second connection pool you created in Step 2: Create the JDBC Connection Pools.

   • The name of the resource must be in the form jdbc/application_nameSequenceDataSource, where application_name is the name of the master index application. For example, jdbc/PersonSequenceDataSource.