The HSQL Database Manager runs on the server machine only

mwringe Sep 11, 2006 3:13 PM

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?

1. Re: The HSQL Database Manager runs on the server machine onl

starksm64 Sep 11, 2006 10:30 PM (in response to mwringe)

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.
Actions
2. Re: The HSQL Database Manager runs on the server machine onl

mwringe Sep 18, 2006 12:08 PM (in response to 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.
Actions
3. Re: The HSQL Database Manager runs on the server machine onl

mwringe Oct 4, 2006 2:00 PM (in response to mwringe)

Has there been any consensus on this?
Actions
4. Re: The HSQL Database Manager runs on the server machine onl

starksm64 Oct 4, 2006 2:41 PM (in response to mwringe)

Yes, it should be removed.
Actions

Go to original post