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
- 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.
- 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/
- 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
- 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.
- 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.