Date: 03/06/05 (Java Web)    Keywords: database, sql

I have noticed that despite closing all connections and exiting a standalone HSQLDB database, at least one connection still remains open. The defect is manifested in HSQLDB 1.7.3 and HSQLDB 1.8.0 RC 8. If you compile and run the sample code below, it will run fine for the first time. Second time (if it is run [...]

Source: http://blog.taragana.com/index.php/archive/how-to-close-all-connections-in-hsqldb-to-prevent-a-locking-defect/