You can debug the hsqldb database by connecting to it using SqlTool.
Create an sqltool.rc like the following:
urlid quartz
url jdbc:hsqldb:hsql://localhost:9001/projectdata
username cms
password hippocms
.. and connect to it with:
java -jar .maven\repository\hsqldb\jars\hsqldb-1.8.0.2.jar quartz