Using Apache Derby Database

Prerequisites

You should have Apache Derby 10.5+ installed.

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

Setting Up the Database for VCL

1. create a database in mysql named for use with VCL

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

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

   svn export https://svn.apache.org/repos/asf/incubator/vcl/trunk/mysql/vcl.sql
   
   chmod a+x derby-parser.pl
   ./derby-parser.pl
   

3. import vcl.sql file into database

   ij vcl-derby.sql