Creating the JDBC Connection Pool and JDBC Resource

The JDBC connection pool and data resource provide the connection information needed by the WLM SE to connect to the Worklist Manager database. You only need to perform these steps if you are using an Oracle or MySQL database.

To Create the JDBC Connection Pool

1. Log in to the GlassFish Admin Console.

   You can access the console from the Services window in NetBeans.

2. In the left portion of the Admin Console, expand Resources, expand JDBC, and then select Connection Pools.

3. On the Create Connection Pool page, click New.

4. Fill in the following information:

   • Name: A name for the connection pool.

   • Resource Type: The Java class to use for Worklist Manager database transactions.

   • Database Vendor: The database platform you are using.

5. Click Next.

6. In the DataSource Classname field, accept the default class or enter a new one to use.

7. In the additional properties section, enter the connection values for the Worklist Manager database. Be sure to enter the following information at a minimum (you might need to create some of these properties).

   • For Oracle:

     • URL – The URL that points to the database. The syntax of the URL is jdbc:oracle:thin:@host:port:database_name.

     • user – The login ID for the user you created for the database.

     • password – The password for the above user.

   • For MySQL:

     • URL – The URL that points to the database. The syntax of the URL is jdbc:mysql://server:port/database_name.

     • user – The login ID for the user you created for the database.

     • password – The password for the above user.

     • DatabaseName – The name of the database.

8. Click Finish.

To Create the JDBC Resources

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.

4. In the Pool Name field, select the name of the JDBC connection pool you created above.

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.