Setup HSQLDB Database for Scoopi

To run examples with persistence we need HSQLDB up and running. Download HSQLDB version 2.3 and extract it to some folder. To create database and start HSQLDB server, run

cd hsqldb-2.3.0/hsqldb
java -cp lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:data/scoopi --dbname.0 scoopi

This creates database named scoopi and places database files in data directory.

Use HSQLDB client to connect running database and to do that run following from another console

java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

To connect to HSQLDB server, enter connection details as shown in the figure and click OK.

Edit conf/jdoconfig.properties and disable mariadb and enable hsqldb properties.