hpersonic missing in JMX console

[lara375]

I am using Jboss 3.2.3 and in the JMX console there's supposed to be a service for hypersonic, right? According to tusc tutorial it should be under JBOSS heading but I don't find that particular service. Do I need to download hypersonic seperately? There's a hypersonic folder in Jboss3.2.3/server/default/data/ and there are two files localDB.properties and localDB.script. Any suggestion?

[spiritualmechanic]

DefaultDS is what it will probably be under. Look for the hsqldb-ds.xml in the deploy directory. You can double-check by looking in the JNDI tree. Compare what's in the hsqldb-ds.xml for <jndi-name> to what you find in the JNDI tree.

If you don't have hsqldb-ds.xml, then you have other problems :)

[jonlee]

Under 3.2.3, Hypersonic is not deployed by default as an MBean service. Read the contents of hsqldb-ds.xml to understand why. Essentially, unless you want access via TCP/IP you don't need the MBean implementation and it does have an performance impact. So there is no MBean listing for the Hypersonic service.

IMHO, the default now gives you better JBoss performance out-of-the-box without having to fiddle too much.

[darranl]

jonlee,

People are not looking for the service because that want to connect to Hypersonic using TCP/IP, they are looking for the service so that they can use the gui to look at their data (As instructed in a number of tutorials).

Do you know if there is any way that the Hypersonic MBean could be changed so that the GUI would be available without actually using TCP/IP?

[spiritualmechanic]

Thanks for the info, Jon. That makes a lot of sense.

[adrian.brock]

It has already been done in JBoss-3.2.4RC1

[jonlee]

Unfortunately, client-server mode is usually the only means of connecting to hsqldb outside of the application (JBoss) JVM. The Database Manager utility for hsqldb requires client-server mode as the Database Manager is an AWT/Swing-based application. More information can be found in the documentation at http://hsqldb.sourceforge.net/. In particular look at the "Operating Modes" and "Running HSQLDB" sections.

However, you might be able to jury-rig the HSQLDB servlet to connect in-process. I haven't really tried this but a cursory glance at the information and code tells me that since the servlet exists in the same JVM as hsqldb in the JBoss configuration, you should be able to get an in-process connection. Or you could rewrite the servlet to make use of JBoss DataSources. I would say that would be the best way to move forward. Otherwise, you will need JDBC (client-server) mode via the MBean to allow the Database Manager to connect.

I haven't had time to look at the the 3.2.4 RC but I assume that Adrian is referring to a servlet console developed for JBoss that has similar or better functionality to the HSQLDB servlet. You should be able to "steal" that for your "production" JBoss deployments, and hopefully with few (if any) hacks to make it work.

I hope I haven't gone off on a tangent here.

[lara375]

Jon,
I was trying out the tutorials at
http://www.tusc.com.au/tutorial/html/chap1.html
Those are some good tutorials for j2ee beginners but unfortunately, they use a version of jboss that does allow GUI based interface to hypersonic. They use jboss 3.2.1. Without the GUI, I won't be able to advance through the chapters in the tutorial. I wonder if 3.2.1 version is still available for download. If you anyone can direct me to that download page, it will be helpful.

[darranl]

Lara,

Have a look at the 'hsqldb-ds.xml' file in the deploy folder.

Read the instuctions that it contains.
Enable the MBean and change the connection to use the TCP/IP connection.

Start JBoss

You will then be able to start the Hypersonic database manager from the JMX-Console.

[lara375]

Hi Darran, wonderful. I can't thank you enough. It's working. I just uncommented the bottom portion that contains mbean code for hypersonic db. You rock.