0 Replies Latest reply on Oct 28, 2005 2:00 AM by mattma

    org.jboss.mq.SpyJMSException: Could not get a connection for

    mattma Newbie

      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