Creating Apache Derby databases for schedulers

This topic describes how to create Apache Derby databases for schedulers using data definition language (DDL) or structured query language (SQL) files.

About this task

To create Apache Derby databases for schedulers, using data definition language (DDL) or structured query language (SQL) files, use these steps.

Procedure

  1. Open a command-line window.
  2. Verify that you have administrator rights for the database system.
  3. Verify that the database supports Unicode (UTF-8). Otherwise, the database does not store all characters that can be handled in Java™ code, which results in code page conversion problems when a client uses an incompatible code page.
  4. Use the ij utility supplied with the Apache Derby system to create the database. To use ij to create a database called scheddb which is located in /opt, for example, you would do the following:
    ij.sh 
    ij>connect '/opt/scheddb;create=true';
    ij>quit;
    The embedded version of Apache Derby supports only one local connection. If the Application Server product is running and accessing a Apache Derby database, then any attempts to open a second connection to the database from the command line are rejected.
    Note: Add a semi-colon (;) at the end of each command. Otherwise, ij does not execute the command.
  5. Exit the ij utility by issuing the quit command: quit;

Results

The Apache Derby database for the scheduler service exists.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Oct 21, 2010 1:44:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-express-dist&topic=tsch_codbcl
File name: tsch_codbcl.html