Using HSQLDB in production environments

Question

I want to use HSQLDB in a production environment for stroring some data in memory and for data export using files. Does anybody have experience with using hsqldb in production environments? Is hsqldb treating server resources gracefully and does it cleanup unused resources properly?

I've seen a critical post on those issues from red hat and I'm wondering whether this still holds for hsqldb:

http://kbase.redhat.com/faq/docs/DOC-15194

Answer 1

I've used hsql on numerous occasions in production (mainly as quick filebased storage for complex preferences) and never encountered any problems.

Answer 2

Don't know about HSQLDB but we've been using H2 on same purposes with no problems at all.