Hypersonic is not a production quality database and MUST not be used in production neither is it suitable for serious development or load-testing
the most problematic issues are listed in this wiki page
We should add a very clear statement to all our documentation and point people to a generic procedure to change the database
project leaders should be aware of the situation and be ready to make the appropriate changes to their project-specific admin guides and other gettting started books.
They should all point to the same section in the AS admin guide...or something like that.