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.
![HSQLDB client](/tutorial/scoopi-web-scraper/media/scoopi-persistence-hsqldbclient.png)
Edit conf/jdoconfig.properties
and disable mariadb and enable hsqldb
properties.