Creating a Cloudscape database for Business Process Choreographer

Use this task to create a Cloudscape™ database for Business Process Choreographer.

Why and when to perform this task

The Cloudscape database system is implemented in the Java™ language. It comes with the WebSphere® Process Server as several Java Archive (JAR) files.

The Cloudscape license that comes with WebSphere Process Server is only for development and test, not for production purposes. Cloudscape cannot be used as database system for Business Process Choreographer in a Network Deployment environment. The Cloudscape version that comes with this product includes the Cloudscape Network Server that supports client/server JDBC access over the Distributed Relational Database Architecture™ (DRDA®) protocol. Because the version of Cloudscape Network Server that is provided with this version of WebSphere Process Server has no XA support, Business Process Choreographer can only use the Embedded Cloudscape version that cannot be accessed remotely.

To create a Cloudscape database named BPEDB, perform the following actions:

Steps for this task

  1. Prepare to run the database creation script file by performing one of the following:
    • To prepare to create the database in the default location, manually create a databases subdirectory in the appropriate profile directory. On Windows systems, create install_root\profiles\Profile_name\databases. On Linux and UNIX systems create install_root/profiles/Profile_name/databases. . Change to the new directory.
    • To prepare to create a database location other than the default location, change to the directory where you want the new database created. If you run the business process container installation wizard, you must remember to specify the fully qualified database location as the value of the custom property databaseName.
  2. Check whether you have Java configured on your server. Enter the command:
    java -version
    If you get an error message, then in step 5, when you run the database creation script, you must prefix the Java command with the full path to the Java executable :
    • On Windows systems, add the path: install_root\java\bin\
    • on Linux and UNIX systems, add the path install_root/java/bin/
  3. Copy the database creation script to the current directory.
    • On Windows system, copy the file install_root\ProcessChoreographer\createDatabaseCloudscape.ddl
    • On UNIX and Linux systems, copy the file install_root/ProcessChoreographer/createDatabaseCloudscape.ddl
  4. Read the instructions in the header of the database creation script, createDatabaseCloudscape.ddl, in an editor. On Windows systems, avoid using the Notepad editor, as it does not display the file in a readable format.
  5. Run the database creation script file. From the directory where the database is to be created, run the database creation script file createDatabaseCloudscape.ddl as described in the header.

Result

The Cloudscape database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

Terms of use |

Last updated: Tue Feb 21 17:31:26 2006

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