The perfect tool for embedding a database in your java application. Not suited for handling larger result sets but it is still the ideal solution to ship with your app when large result sets are not a requirement.
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 4 star reviews.