views:

46

answers:

1

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.

A: 

The answer is: this question is misguided.

Even if I could enumerate catalogs served by an HSQLDB "Listener" (server), I'd still need a privileged login -- one per catalog -- to issue the SHUTDOWN commands. Thus, there would still be the need for external config information, which is what I wish to avoid.

SIGTERM support would be a lot easier. :)

pilcrow