Step 3: Create the JDBC Resources

Note - MySQL is only supported in Java CAPS 6 Update 1. You only need to create the sequence connection pool if you are using Update 1.

A JDBC resource (also known as a data source) gives the master index application the ability to connect to the database. Two JDBC resources are required.

To Create the JDBC Resources

Before You Begin

Create the JDBC connection pools, as described in Step 2: Create two 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 two 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 previous steps to create a JDBC resource for the sequence manager with these guidelines:

   • In the Pool Name field, enter the name of the second JDBC connection pool you created.

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