Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Hi All

Thanks for all the information and suggestions from everyone!! Appreciated!!

First of all an apology from me - Re: "Hi-jacking" a thread. I'm on a couple of other "lists" and on these I only have to change the Subject Line to start a new thread - and I keep forgetting that the LO list DOES NOT work this way!! Will try to remember in future!!

To Andreas and Alex a special thank you for your help! Do I have a back-up file, Yes, but about a month old so I will have lost some work but that's not too serious. I also tried to open the .odb file after renaming it as a .zip but nothing opens although it is over 40Mb in size!!

I next followed up on the suggestion to use HSQLDB as an external engine. My LO Installation is using Java 1.6.0_31 and was not showing any problems so have not had to go back to 22!

To set the Class Path I had to search for hsqldb.jr and found it under /opt/libreoffice/program/classes.

I then copied the sample file, extracted it and renamed the files as suggested. I put them into /home/FS/Database/FilterData.

I then created a New Database using JDBC with the Datasource jdbc:hsqldb:file:/home/FS/FilterData.db

I set the Driver Class to org.hsqldb.jdbcDriver (And the "Test Driver" button says "Installed correctly"). I set the User Name to 'SA" with no Password. I "registered" the Database and opened for editing. I was then asked for the location so selected that.

I then get an error Box - "Connection could not be established". It complains that the Properties file is not found and that - no such file or directory. (The Properties file IS at that location but there is NO file!!)

(I made the three files in FilterData all rwx and tried again but got the same error!!)

Where have the wheels fallen off??

As a last point I have my backup copy of the file running OK on the system with the embedded engine but am VERY keen to get this external method working!!

Thanks guys

Ian Whitfield


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.