HyperSQL Database Engine (HSQLDB)

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.

This HSQLDB rather good one, but it's too complicated for user with low and average exp!

Good analog SQL database

Never had more headache then with this database. It's compliance with standards is below my own limit of understanding. Writing portable sql with it is exercise in vanity. I have to stick with it, it gets work done, but at what cost? Never a beautiful expressive sql that i write with other db's. Only basic stuff.