Error creating databse Dukes Bank sample

[leduke]

Hi !


I use JBoss 3.2.3 and i'm installing the dukes bank sample.

I'm at the step of creating the database and when i excute this line :

ant -f jboss-build.xml db-create-table

I got this error message, can anyone help me ? Thanks a lot !!

Buildfile: jboss-build.xml

db-create-table:
[java] java.sql.SQLException: Connection is broken: Connection refused: con
nect
[java] at org.hsqldb.Trace.getError(Unknown Source)
[java] at org.hsqldb.Trace.error(Unknown Source)
[java] at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)
[java] at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
[java] at org.hsqldb.jdbcConnection.<init>(Unknown Source)
[java] at org.hsqldb.jdbcDriver.connect(Unknown Source)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:512)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:172)
[java] at org.hsqldb.util.ScriptTool.execute(Unknown Source)
[java] ScriptTool.init error: Connection is broken: Connection refused: con
nect
[java] at org.hsqldb.util.ScriptTool.main(Unknown Source)
[java] java.lang.NullPointerException
[java] at org.hsqldb.util.ScriptTool.execute(Unknown Source)
[java] at org.hsqldb.util.ScriptTool.main(Unknown Source)
[java] Exception in thread "main"

[java] Java Result: 1

BUILD SUCCESSFUL
Total time: 1 second

[tparso]

hey,
I'm having the same problem. I've followed all the instructions (I think), anyone know what the probelm is?

[ir]

Same problem for me too. Anybody has any solution for this ????

Thanks,
SR

[ir]

I solved this problem. Ensure that the hsqldb-ds.xml modifications are placed in the directory that is appropriate for the mode you are starting jboss in. THis means that you should have this file modified in "JBOSS_HOME\server\default\deploy" if you are starting the jboss in default mode. It should be in "JBOSS_HOME\server\all\deploy" directory if you are starting all serverice of jboss. If you are just using "run.bat" like me then it gets started in default mode.

Good luck.
Sanjay

[ryan48sg]

I had this problem too.
The notes here pointed me to the solution.
Thanks for that... here is a clarification on
what you have to do.

When doing the Dukes Bank tutorial, you must
run -c all
to start JBoss. Just using run does not start the
'all' server that Dukes Bank set things up in.

Peter