Hsqldb is great! Thanks.
This database is very problematic for debugging as error reporting is very poor. This puts the onus on the user to dig into the code to find out where an exception is coming from instead of actually using the error text. One example is a simple right hand truncation error where text is too long for the column width. This results in the error message "data exception: string data, right truncation" in which neither the column nor the text value causing the problem is highlighted. Thus, a programmer has to look at all the text columns and text values to check which is causing the problem. That is a major waste of time and constitutes an obnoxious approach to programming. There are plenty of other examples like this so if you can avoid this DB do so until the authors decide that error reporting is important.
There are no 3 star reviews.