[Hsqldb-user] Questions on corrupt DB

[Bayless K. <bk...@co...>]

I switched from McKoi to HSQLDB well over a year ago in the development =
phase of a rather complex 100% Java point-of-sale project. The switch =
was due to stability problems with McKoi and I have had no problems =
since. The system runs under Windows XP Pro. It consists of a cash =
register module that maintains the database and a networked back office =
computer for management use both with 1GB memory and fairly large disks. =
It has been live since late July with plenty of activity and no database =
problems at all.

I updated from Java 5.0 to 6.0 a couple of days ago. Then after just a =
few transactions today, the database suddenly became corrupted in some =
way. Attempting to acces some tables gave an "out of memory" error even =
when just trying to list records in a relatively small table. The only =
other clue I have is that the .data file was almost, if not exactly, =
double the size it should have been. It was 262MB and should have been =
131MB. I reloaded a backup from last night and all went well the rest of =
the day. I also reverted back to Java 5.0 just for sanity.

First question is: Are the above enough clues to make a guess as to what =
might have gone wrong?

Second question: Does HSQL have any tools that might be able to correct =
a corrupted database?

Thanks in advance for any advice I can get on this matter.

Bayless Kirtley