To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55496 Issue #:|55496 Summary:|embedded databases are prone to data loss Component:|Database access Version:|680m130 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|oj Reported by:|fs
------- Additional comments from [EMAIL PROTECTED] Wed Oct 5 04:28:54 -0700 2005 ------- Embedded (HSQLDB) databases are prone to data loss in case of abnormal terminations of the OOo process. That is, if you write data into a database (by UI or by scripting), this data is not immediately commited to the database (the .odb) file, but still stored in some temporary location. If now OOo terminates (crashs, or is killed) abnormally, then this data is lost - not even the document recovery which (perhaps) offers to restore the database upon next start does catch the data. This is certainly undesired behavior for a database. While it's difficult to fix this with our current approach, where the data is just some sub-streams in a ZIP package, we need to somehow address this. I fear this might in fact only be possible with a package format (replacing the ZIP package format for this purpose) which allows O(1) random access to all of its parts. For the record: We tried to relax the situation for OOo 2.0.1 with fixing issue 55493: we introduced a few places where the changes in the DB data are synced back to the .odb file. They're (hopefully) often enough to significantly reduce the chance for a data loss, and seldom enough to be seriously noticed. Nevertheless, this is not really a final solution. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
