The HSQL Database Manager runs on the server machine only

[mwringe]

I have noticed some rather strange behaviour with the org.jboss.jdbc.HypersonicDatabase MBean and the HSQL Database Manager.

Through the jmx console, there is an option to start the HSQL Database Manager by invoking startDatabaseManager() for this mbean. But, this starts the database manager swing application on the server machine, even if the mbean is invoked through a browser on another machine. There is also no message that the application started somewhere else.

Is this expected behaviour?

The startDatabaseManager() mbean option just sets the proper settings for the manager and opens it in a new thread. Wouldn't a separate script make more sense?

[starksm64]

Yes its expected. startDatabaseManager() is just a simple hook to launch the native db manager app. A more general jdbc application like DbVis that can deal with multiple databases is generally what I use. If anything I would argue that the startDatabaseManager op be removed from the hsql mbean.

[mwringe]

Agreed, I think this should be removed from the mbean as well. And just give instructions on how to run the HSQL Database Manager separetly or provide a very simple script to run it.

[mwringe]

Has there been any consensus on this?

[starksm64]

Yes, it should be removed.