I'd like to script the clean shutdown of an HSQLDB 2.0.0-rc9 "Listener" (server).
Is there a way to interrogate an HSQLDB server to determine the catalogs (databases) it is currently serving, either via sqltool
or HSQL client programming?
Background: If I understand correctly, safely shutting down an HSQLDB "Listener" process (an org.hsqldb.server.Server
) requires closing each served catalog (database) with a SHUTDOWN command. Presently, the *NIX init scripts shipped with HSQLDB require the administrator to maintain a separate list of catalogs to be shut down, introducing the possibility of error by misconfiguration.