Am 01.03.2012 23:02, Mark Stanton wrote:
Was that instability with an "internal" HSQL database?
One small step for mankind...
The .odb file claims to be a document but in fact it is an extension.
When you open the file and then open one of its objects, the embedded
HSQLDB will be extracted to the temporary office directory so it works
exactly like an external database in cached mode.
If your form/report/other office component crashes during this
installation process, the whole backend database is lost. Similar
problem when you close the "document" and something weird happens during
the repackaging. Sometimes you can reconstruct the backend from the
According to the forums, the total loss of an embedded HSQLDB happens
quite often. This flaw is the total knock out for any program that
claims to be a database.
I used to use one fairly complex embedded HSQLDB for a period of 18
months. The development time was a full weekend for the backend and
simple forms plus another weekend for the advanced forms. I worked with
it one hour per work day beeing the one and only operator of that thing.
It grew up to a document size of 5 MB. I made a backup before every
session but this particular file always worked reliably and never
crashed. I did not need any macros at all since I know some SQL tricks
and I am not miffed because of one click more than necessary.
So yes, I made my own positive experience with that "embedded HSQL".
Nevertheless setting up a database server in order to work with "the
real thing" is such a tiny effort and it can give so much more safety,
security and performance that I do not recommend the embedded version.
For unsubscribe instructions e-mail to: email@example.com
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
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