Le 18/11/2014 12:35, Alan Pedder a écrit :
Is is a know issue that it is unstable ? In addition I set auto save and backup yet fail to find
Yes, unfortunately a known and frequent phenomenon with the default
provided embedded hsqldb implementation.
You might get more mileage out of it by upping the memory available to
the Java process that is used - there is a setting for this that you
would have to manually add to the script or properties file (these files
are to be found within the ODB file, which is simply a zipped container
for the database setup). Read the hsqldb 1.8 documentation before
fiddling with these though.
Autosave doesn't work for Base documents, if it produces anything at
all, then it will be a series of 0 byte files.
This is currently bug 71550.
Any help will be very appreciated and I am ok to provide my database for analysis if required by
genuine helper and would pay on results if necessary.
No need to provide it here, your database is probably corrupt judging by
the symptoms you are experiencing. I hope you have some kind of stable
backup or copy of the ODB file somewhere else that you can work from, or
at least re-purpose, in order to connect your front end (forms, queries,
etc) to a more reliable backend db system.
HSQLDB is reliable enough outside of the embedded scenario defined as
the default in LO Base. There are tutorials in the OpenOffice.org forum
and the LO Base Handbook which explain how to set up a split hsqldb
Alternatively, people use a variety of other db backend engines :
MySQL / MariaDB
Firebird (not the embedded version that ships experimentally with LO,
but the standaloe server version)
Obviously, not all engines will be suited to what you want to do, or are
willing to administrate, etc, so it would be best to do your homework
beforehand to make up your mind.
To unsubscribe e-mail to: firstname.lastname@example.org
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
[libreoffice-users] Re: Base Help Anyone · Alexander Thurgood
[libreoffice-users] Re: Base Help Anyone · Andreas Säger
Impressum (Legal Info)
: 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