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

Am 01.03.2012 23:02, Mark Stanton wrote:
Hi Andrew,

Was that instability with an "internal" HSQL database?

Mark Stanton
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 temporary files. 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:
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.