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.