9 Replies Latest reply on Apr 19, 2004 8:51 PM by lara375

    hpersonic missing in JMX console

    lara375 Newbie

      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?

        • 1. Re: hpersonic missing in JMX console
          Steve Lewis Expert

          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 :)

          • 2. Re: hpersonic missing in JMX console
            Jon Barnett Master

            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.

            • 3. Re: hpersonic missing in JMX console
              Darran Lofthouse Master


              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?

              • 4. Re: hpersonic missing in JMX console
                Steve Lewis Expert

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

                • 5. Re: hpersonic missing in JMX console
                  Adrian Brock Master

                  It has already been done in JBoss-3.2.4RC1

                  • 6. Re: hpersonic missing in JMX console
                    Jon Barnett Master

                    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.

                    • 7. Re: hpersonic missing in JMX console
                      lara375 Newbie

                      I was trying out the tutorials at
                      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.

                      • 8. Re: hpersonic missing in JMX console
                        Darran Lofthouse Master


                        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.

                        • 9. Re: hpersonic missing in JMX console
                          lara375 Newbie

                          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.