Hi Andrew, > [data loss in embedded HSQLDBs when crashing] > As I read the ranking documentation for issues this is a P2 because that > is where you put data loss.
Yes. > But, you have to admit that for a database manager this is the whole > ball of wax. I mean the way this is, people are going to lose data > and the problem is they can lose it long after they would reasonably > assume that it is safely tucked away on disc. I do not really want to "discuss" this problem "away" - data loss is a serious thing. The differences in perception might just be about how often it is really encountered in "real life". There are two arguments I could bring which I think slightly relax the situation for practical use (which might be considered lame from a theoretical point of view): 1) There's a "auto-save backup files" functionality, which by default saves a current snapshot every 15 minutes. This should also include your recent manipulations to the DB, even if they're not yet part of the .odb. 2) OOo shouldn't crash too often :-\ Wasn't stability one of the goals for 2.0 ...? Anyway, in general you're right and this is a problem. I submitted issue 55274 to track this - feel free to add your comments. I will take this discussion as inducement to think about concepts how we can relax the problem for 2.0.1 (we might not be able to completely fix it in this time frame). In general, this would be about defining more situations where the DB content is synced into the .odt file. Currently, it's "the last connection dies" and "OOo terminates properly" - which, as you outlined, might be too seldom. I am aware of the fact that this is a workaround only. Normally, you would expect from a database that when you write a record, and unplug your machine afterwards, that the data is still preserved and present in the next run. Admittedly, this will be difficult to reach with 2.0.x :-\ Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
