The business process container requires a database. This topic
describes how to create the database for Business Process Choreographer.
Why and when to perform this task
In a clustered Business Process Choreographer setup, one database
is shared between all cluster members. In a non-clustered setup, the database
is dedicated to the business process container and human task container on
a single application server.
Steps for this task
- On the server that hosts the database, create the database according
to the description for your database system.
- On each server that runs Business Process
Choreographer without a local database, you must make the remote database
accessible:
- Install a suitable database client or Java™ Database
Connectivity (JDBC) driver on the server that hosts the application server.
- If you are not using a type-4 JDBC driver, make the new database
known to the database client as follows:
- For Cloudscape
- No action is required, because Business Process Choreographer supports
only the embedded version of Cloudscape, which does not support remote access.
The Cloudscape Network
Server is not supported, because it has no XA support.
- For DB2
Universal Database™
- The database must be cataloged and accessible through an alias name.
- For Informix Dynamic
Server
- This step does not apply because only the type-4 JDBC provider is supported.
- For Microsoft SQL Server
- This step does not apply because only type-4 JDBC providers are supported.
- For Oracle
- The TCP net service name (TNS) is used to access the database.
- Test the connection to the database.
- Click
- If necessary, select a different scope and click Apply.
For clustered Business Process Choreographer configurations, the data source
can be defined at the cluster level or server level. For non-clustered configurations,
the data source is defined at the server level.
- Click
- Locate the appropriate data source, BPEDataSourcedatabase.
For example, BPEDataSourceCloudscape.
- Select the check box for the data source, and click Test connection.
- You should see a message indicating that the test connection was successful.
Result
The Business Process Choreographer database exists and is accessible
from the servers that host the application server and the deployment manager.
What to do next
Continue configuring
in the
parent topic at step
4.