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.
- 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
- 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/
- 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.
- 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.
- If you also want Business Process Choreographer Observer
to use this database, perform the following:
- 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/.
- 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.
- 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.
- 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.