You can create a JDBC data source to connect to the workflow
system database and common base event adapter databases.
Use the following steps to create the JDBC data sources:
- Create a JDBC Provider for connecting to the workflow system
data.
- On the Administrative Console, select .
- Click New.
- Select the database type.
- Select the provider type:
- Select Connection pool data source for
the Implementation Type.
- Click Next.
- Click Apply.
- Create a Data Source for connecting to the workflow system.
- Click Data Sources.
- Click New and specify the following
information.
- Enter a name for the data source.
- Enter jdbc/com/ibm/P8/BPM/PEDataSource for
the JNDI name.
- Clear Use this Data Source in container managed persistence
(CMP).
- For Component-managed authentication alias, use the <Node>/<alias> selection
for the workflow system alias created previously.
- Enter the workflow system database name.
- Enter the workflow system database server name.
- Enter the workflow system database port number.
Tip: The
last three bullets are not specified for Oracle. Instead, specify
a single "URL" property. The Oracle JDBC Driver DataSource requires
the following URL entry, in place of the workflow system database
name and port. Enter the URL in the following form:
jdbc:oracle:thin:@<host_name>:<port>:<instance_name>
- Click OK.
- Click Save to Master Configuration,
then click Save.
- Check the box for the data source, and click Test
Connection to verify connectivity.
- Create JDBC driver for connecting to the BPMSTATE database.
- In the admin console menu, select .
- Click New.
- Select DB2 for the database type.
- Select DB2 Universal JDBC Driver Provider for
the provider type.
- Select XA data source for the
Implementation Type.
- Click Next.
- Click Apply.
- Create a data source for connecting to the BPMSTATE database.
- Click Data Sources.
- Click New and specify the following
information:
- Enter a name for the data source.
- Enter jdbc/com/ibm/P8/BPM/CBEAdaptor/EventStateDataSource for
the JNDI name.
- Clear Use this Data Source in container managed persistence
(CMP).
- For Component-managed authentication alias, use the <Node>/<alias> selection
for the common base event adapter event state alias created previously.
- In Authentication alias for XA Recovery, select Use
component-managed authentication alias.
- Enter BPMState for the Database name.
- Enter the database Port Number.
- Click OK.
- Click Save to Master Configuration,
and then click Save.
- Select the check box for the data source, and click Test
Connection to verify connectivity.