hsqldb connection problem

[coplenish]

I am new to Jboss and want to set up Nukes to try it. However I am having problems connecting to hsqldb

I have started jboss 3.2.1. Hypersonic shows that it is running. When I try to connect using either HSQL database manager or Squirrel I get an error message. In HSQL DB manager the message is java.sql.SQLException: Connection is broken: Connection refused: connect.

Can anyone provide some insight into how to fix this problem.

[raphael2]

Veriry the hslbd-service file and login-config.xml and look at the hsqldb console what port it's running. By default the hsqldb running at 8887 port, and the jboss is configured to 1476 port.

Try this !!!!!!!!!!

Regards, Raphael Luiz Nascimento

[johnraz]

from hslbd-service

<connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>

I can connect, but the tables I am creating are not found.

Any idea ?

Where is the documentation for the hypersonic manager ?

Thanks

[pinpooh]

I downloaded hsql1.7.1 from sf.net, and there is some documentation with it. I know noting about Nukes, but if you use hypersonic as a DataSource, make sure you have the tag "create-table" set to true in the jbossCMP-jdbc.xml, in the conf dir.

// pinpooh