Creating the database for the business process container

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 serves all the business process containers in the WebSphere® cluster. In a non-clustered setup, the database is dedicated to the business process container on one application server.

Steps for this task

  1. On the server that hosts the database, create the database according to the description for your database system.
  2. On each server that runs Business Process Choreographer without a local database, you must make the remote database accessible:
    1. Install a suitable database client or Java™ Database Connectivity (JDBC) driver on the server that hosts the application server.
    2. 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.
    3. Test the connection to the database.
      1. Click Resources > JDBC Providers
      2. If necessary, select a different scope and click Apply. For clustered Business Process Choreographer configurations, the data source can be defined at the cell level or server level. For non-clustered configurations, the data source is defined at the server level.
      3. Click provider_name > Data sources
      4. Locate the appropriate data source, BPEDataSourcedatabase. For example, BPEDataSourceCloudscape.
      5. Select the check box for the data source, and click Test connection.
      6. 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.

Terms of use |

Last updated: Thu Apr 27 14:54:57 2006

(c) Copyright IBM Corporation 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)