The path to the
hsqldb.jar file is set this way.
On the main Libreoffice menu, choose Tools/Options/Libreoffice and look for Java or Advanced. Click the Class Path button, and then Add Archive. Navigate to the location where the
hsqldb.jar file is (apparently,
/var/lib/hsqldb/lib/hsqldb.jar, in your case)
On my Debian system
/usr/share/java/hsqldb.jar is a link to the actual file
/usr/share/java/hsqldb-188.8.131.52.jar. Both belong to
Step 3 is what you have illustrated with your screenshot. Put the properly modified (for your database) long command "
jdbc:hsqldb:file:/home/chenier/hsqldb/name;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false" in the datasource url, and put "
org.hsqldb.jdbcDriver" (without the quotes in both cases) in the JDBC Driver class box. Test the class. The next part asks for a user name; use "
SA" (without quotes), leave the password required unchecked, and test the connection.