How to set up the jdbc driver to connect to hsqldb from libreoffice?

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-1.8.0.10.jar. Both belong to root.

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.