-
1. Re: hpersonic missing in JMX console
spiritualmechanic Apr 17, 2004 7:37 PM (in response to lara375)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
jonlee Apr 17, 2004 9:34 PM (in response to lara375)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
darranl Apr 18, 2004 8:59 AM (in response to lara375)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? -
4. Re: hpersonic missing in JMX console
spiritualmechanic Apr 18, 2004 9:08 AM (in response to lara375)Thanks for the info, Jon. That makes a lot of sense.
-
5. Re: hpersonic missing in JMX console
adrian.brock Apr 18, 2004 9:15 AM (in response to lara375)It has already been done in JBoss-3.2.4RC1
-
6. Re: hpersonic missing in JMX console
jonlee Apr 18, 2004 9:46 AM (in response to lara375)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 Apr 18, 2004 11:34 PM (in response to 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. -
8. Re: hpersonic missing in JMX console
darranl Apr 19, 2004 5:47 AM (in response to lara375)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. -
9. Re: hpersonic missing in JMX console
lara375 Apr 19, 2004 8:51 PM (in response to 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.