Re: [libreoffice-users] Re: Urgent Base problem

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 Properties.new 
- no such file or directory. (The Properties file IS at that location 
but there is NO Properties.new 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
Pretoria.


/
/

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted