Using Apache Derby Database

Prerequisites

You should have installed:

• JDK

Setting Up the Database for VCL

1. Download Apache Derby and install

   cd ~
   wget http://apache.g5searchmarketing.com/db/derby/db-derby-10.5.1.1/db-derby-10.5.1.1-bin.tar.gz
   tar -xzf db-derby-10.5.1.1-bin.tar.gz
   mkdir /opt/Apache
   mv db-derby-10.5.1.1-bin /opt/Apache/derby
   export DERBY_HOME="/opt/Apache/derby"
   export CLASSPATH="${DERBY_HOME}/lib/derby.jar:${DERBY_HOME}/lib/derbytools.jar:${CLASSPATH}"
   PATH="$DERBY_HOME/bin:$PATH"
   

2. create a database in Apache Derby named for use with VCL

   ij
   connect 'jdbc:derby:vcl1;create=true;user='vcluser';password=vcluserpassword;';
   

3. get vcl.sql file and the derby-parser.pl

   svn export https://svn.apache.org/repos/asf/incubator/vcl/trunk/mysql/vcl.sql
   wget http://cwiki.apache.org/confluence/download/attachments/115523/derby-parser.pl
   chmod a+x derby-parser.pl
   ./derby-parser.pl
   

   NOTE: You may want to edit derby-parser.pl and insert the correct user name and password.
4. import vcl-derby.sql file into database

   ij vcl-derby.sql