To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65466 Issue #:|65466 Summary:|Direct hsqldb modifications to an odb file disappear Component:|Database access Version:|OOo 2.0 Platform:|Macintosh URL:|http://www.cs.rice.edu/~dlsmith/spam.odb OS/Version:|Mac OS X Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|dansmith
------- Additional comments from [EMAIL PROTECTED] Tue May 16 14:07:38 -0700 2006 ------- I'm trying to make programmatic changes to a OOo database without the pain of setting up a database server. My solution is to: 1) Create a database in OOo using the default hsqldb embedded data format 2) Close the file, unzip it, rename the files in "database/" to "foo.data", "foo.script", etc. 3) Programmatically insert data using a Java application with the hsqldb jdbc driver 4) Rename the "database/" files to their original names, and re-zip the odb file 5) Open and browse the new odb file This works satisfactorily (although a more direct option would be nice). However, under some conditions, the data I have programmatically inserted into the database will not appear under OOo, while data I inserted manually via OOo does show up. Specifically, the original filename seems to be linked to this behavior -- I can avoid it by simply renaming my file. There are apparently two sets of data: the manual set (entered via OOo), and the programmatic set (entered directly via hsqldb). When I open my file in OOo, I see the manual set, but not the programmatic set. If I rename the file and open it in OOo, I see both sets. If I add data to the renamed file, it is visible both in OOo and via hsqldb. If I add data to the original file, it will be visible in OOo, but not via hsqldb; and when I rename the file *after* adding data, the new data is no longer visible. The only other unusual thing I'm noticing is that the layout of the table I'm manipulating was set in the original file (columns and rows are wider/taller), and those layout settings are not present in the renamed file. I suppose there may be some link. If so, the bug is probably only evident in the context of my system, and the referenced example file will not demonstrate the bug anywhere else. The file I'm having trouble with is at the linked URL. It contains a "MESSAGES" table that should have 10 records, but when the bug is evident, only has 4 records. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]