Trouble connecting to built-in HSQL using SQuirreL

[siegfried1]

I'm following the instructions at http://wiki.jboss.org/wiki/Wiki.jsp?page=NukesUsingHSQLDB to connect to the interal HSQL built-into JBoss. I want to see the results of my interaction with the web interface.

I'm running the initial helloworld application from "JBoss Seam" by Yuan and Heute.

When I try to connect to the internal HSQL database using SQirreL, I get "JBoss: socket creation error".

What am I doing wrong?
Thanks,
Siegfried

ava.sql.SQLException: socket creation error
 at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
 at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
 at org.hsqldb.jdbcDriver.connect(Unknown Source)
 at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
 at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
 at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:279)
 at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
 at java.lang.Thread.run(Thread.java:619)

[pmuir]

That page is ancient.

Take a look at the dvd example, that exposes an mbean which you can connect to using the JMX console.

[siegfried1]

Take a look at the dvd example, that exposes an mbean which you can connect to using the JMX console.

Can you give me a hint as to where I might find that example?

I looked in the examples in the book, my JBoss distro, and finally google searched but could not find it.

Thanks,
Siegfried

[nickarls]

I think it is the "seamdiscs" example from

http://fisheye.jboss.org/browse/JBoss/jboss-seam/examples/seamdiscs

[pmuir]

That works as well

http://fisheye.jboss.com/browse/JBoss/jboss-seam/examples/dvdstore/resources/jboss-seam-dvd-ds.xml?r=1.1

[siegfried1]

Is there a text file that explains how to download this example, deploy it and run it?

[pmuir]

It's in the seam distribution. Take a look at the examples readme.