Hi Andy, > I posted to OOForums a little enquiry about how you are accessing HSQL > files in the zipped .odb file. I'm writing some standalone java code to > access an odb file. I've seen plenty examples in the SDK for calls to an > instance of UNO, but can this be done with reference to a self contained > jar? Otherwise I just had some simple questions such as what is > happening with the zipping, like how you appear to have hsql locking and > reading directly from the zip.
Conceptually, we unzip the files from the .odb (they're all located in the "database" sub folder of the zip), and let HSQLDB work on those external copies, as if they were a normal file-based database. From time to time (too often to be really unobtrusive, but too seldom to really guarantee your data is there even if you pull the plug just after you entered it), the copies are synced back to the .odb. This is probably also the way you should be going. (Note that technically, it's not exactly like this. Instead, we use a feature of HSQL to use some kind of virtualized file access, and re-route all its file access operations to our .odb-external copies of the files in the "database" sub folder.) > Many thanks. Hope this is an appropriate place to post. Not bad, though Ariel is right with trying to attract you to [EMAIL PROTECTED] with this :) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
