I'm posting this in case others run into this situation and need a solution.

I had a rare case where I got the

org.jboss.mq.SpyJMSException: Could not get a connection for jdbc2 table construction ; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException:...

which was *NOT* caused by an instance of the database already running. It was actually because some uncommitted transaction in the hypersonic db was trying to be inserted and my jboss 3.2.3 deployment complained about an invalid sql insert statement.

In this case, the way to stop jboss from even trying to commit uncommited transactions at start up, you simply go to

jboss/server/default/data/hypersonic

and delete all files. The server will not have any uncommitted transactions to commit after that.

---------------------
Matthew Ma
Lightspoke Web-Based Database