This gist walks you through the steps of setting up a storage for your datomic starter instance to use an HSQLDB instance (running as a standalone server - i do not address embedded, http, in memory or other forms of the server). I am sure the same can be applied to any other SQL based storage so it should be portable to Apache Derby. I am writing this for those who may find it useful in getting this done quickly without spending a week as I did trying to figure out what I was doing wrong.
- Download the latest version of the database from here
- The most important file you will need is the hsqldb.jar file. This is the database. This will need to be in your classpath to be able to run the server.
- I then create a bash script for easy execution of the Network Server version of the database as shown below.