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 this site ( How to set up the jdbc driver to connect to hsqldb from libreoffice? ) 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 (sorry can't recall which) 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 and it is still not finding it.
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 am running LibreOffice 4.0 on Ubuntu 12.04 LTS.
Any suggestions?