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. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831265#3831265 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831265 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user