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. Copy the database creation script to the current directory.
    • On Windows system, copy the file install_root\dbscripts\ProcessChoreographer\Cloudscape\createDatabase.sql
    • On UNIX and Linux systems, copy the file install_root/dbscripts/ProcessChoreographer/Cloudscape/createDatabase.sql
  3. 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/
  4. Read the instructions in the header of the database creation script, createDatabase.sql, 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 createDatabase.sql as described in the header. Do not use the cView tool to run the script.
  6. If you also want Business Process Choreographer Observer to use this database, perform the following:
    1. Copy the following SQL scripts to your database server:
      clearSchema_Observer.sql 
      createDatabase_Observer.sql 
      createSchema_Observer.sql 
      dropSchema_Observer.sql
      • On Windows system, the SQL files are located in install_root\dbscripts\ProcessChoreographer\Cloudscape.
      • On UNIX and Linux systems, the SQL files are located in install_root/dbscripts/ProcessChoreographer/Cloudscape/.
    2. In a text editor, read the instructions in the header of the script file createSchema_Observer.sql. On Windows systems, avoid using the Notepad editor, because it does not display the file in a readable format.
    3. Create the schema. From the directory where you created the database, run the script file createSchema_Observer.sql as described in the header of the script.
    4. In case of errors, you can run the script file dropSchema_Observer.sql to drop the schema.

Result

The database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

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