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.