Set up the Apache Derby databases manually

We can set up the Apache Derby database manually, instead of by running Ant tasks.

Set up the Apache Derby database by creating the database schema.

1. In the location where you want the database to be created, run ij.bat on Windows systems or ij.sh on UNIX and Linux systems.

   The ij program is part of Apache Derby. If we do not already have it installed, we can download it from Apache Derby: Downloads.

   For supported versions of Apache Derby, see System requirements for using MPF. The script displays ij version number.

2. At the command prompt, enter the following commands:

   connect 'jdbc:derby:WRKLGHT;user=WORKLIGHT;create=true';
   run 'MF_HOME/WorklightServer/databases/create-worklight-derby.sql';
   connect 'jdbc:derby:WLREPORT;user=WORKLIGHT;create=true';
   run 'MF_HOME/WorklightServer/databases/create-worklightreports-derby.sql';
   quit;

Parent topic: Configure the Apache Derby databases manually