I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on Super User ( http://superuser.com/questions/555325/how-to-set-up-the-jdbc-driver-to-connect-to-hsqldb-from-libreoffice/560192#560192 ) to get the Class Path working fine when I pointed it to the correct location for my HSQL 2.2.8 and restarted LibreOffice.
In Edit > Database > Properties I used Test Class and it successfully connected to the JDBC driver. That part worked fine. But then when I test the connection it keeps saying that the file is not found. I checked the file path again and again, tried moving it to different locations but its not working. I first had tried it with the mydb.file.odb that I found on a LibreOffice/OpenOffice forum and that connection would not work. So I copied the Data Class URL from the other post mentioned above changing the file path as needed pointing it to where I had saved the extracted and renamed files and it still says that it does not exist.
The error message I get is: SQL Status: S1000
Error code: -451
Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@d016958c[file =/Home/Databases/ManualDB/ManualDB.lck, exists=false, locked=false, valid=false, ] method: openRAF reason: java.io.FileNotFoundException: /Home/Databases/ManualDB/ManualDB.lck (No such file or directory)
I saw something somewhere that a wildcard (~) can be used with HSQL 2.x to find the current user, but I am not sure how to do this or if this is in fact the issue.
I am running LibreOffice 4.0 on Ubuntu 12.04 LTS.