Re: [Hsqldb-user] Total database loss due to .backup file not unz ippable

[Heilveil, A. <alh...@sp...>]

What I know so far is:

) The zip file is truncated
) The properties file has modified set to yes
) there are no .old nor .new files.

Under these conditions the .new and .old and .data files are wiped on
startup, then the .backup file is unzipped and since it is corrupt all is
lost. 'modified' being yes suggests that I am missing an error returned from
the shutdown sql command. I have added additional logging to my app at that
point.  

So far I have added testing the zipfile integrity to my startup so that I
can not startup  the database if that is bad. This will at least retain all
the files as they were after the shutdown. 

I am also thinking of replacing sun's native code zlib support with a pure
java implementation. That would let me make sure that problems with
compressing actually get signaled all the way back to my application.