To Set Up the BPEL Database

Before You Begin

If you are using an Oracle database, copy the driver file (ojdbc14.jar) from your Oracle installation to GlassFish_Home/glassfish/lib, and then stop and restart the GlassFish server.

1. Configure the user and database as described in Configuring the User and Database for Persistence in Using the BPEL Designer and Service Engine.

2. Create one XA connection pool and JDBC resource and one non-XA connection pool and JDBC resource.

   This is described in Creating an XA Connection Pool and a JDBC Resource in Using the BPEL Designer and Service Engine and Creating a Non-XA Connection Pool and JDBC Resource in Using the BPEL Designer and Service Engine.

3. For each JDBC resource you created, return to the JDBC Resources page on the GlassFish Admin Console and do the following:

   1. Select the JDBC resource from the list, and then click the Target tab.

   2. Click Manage Targets.

   3. Under Available Targets, select the cluster and click Add.

   4. Click OK.

   5. In the Targets table, select the cluster and then click Enable.

4. To automatically create the database tables, do the following:

   1. In the NetBeans Services window, expand Servers > GlassFish V2 > JBI > Service Engines.

   2. Right-click sun-bpel-engine, and then select Start.

   3. On the Properties window, enable persistence and update the names of the XA and non-XA data source fields to match the JDBC resources you created above.

   4. Stop and start sun-bpel-engine.

   5. Shutdown sun-bpel-engine.