By default, hsqldb does not write any data to its database file until the server is shut down. Instead it keeps a redo log. Perhaps for a system such as Jira using 'CREATE CACHED TABLE' instead of 'CREATE TABLE' would be more appropriate?