Quote of a Quote from Dan Debrunner
I'm not sure how hsqldb can be used as a test database, given that
multiple threads can overwrite each other, due to hsqldb only supporting
dirty read mode (no isolation). Thus if you see incorrect results it
seems you have to work out if hsqldb is the problem or your application.
Unit tests are usually single-threaded, so this isn't a problem. Having a better option (in-memory derby) would be even better though =)
-Brian
