5 Replies Latest reply on Mar 5, 2005 6:04 PM by ccsdev

    XAConnectionFactory not bound on Startup

    ccsdev Newbie

      Hi. I know that this question has been posted a great number of times. But for the life of me I haven't been able to see what could be wrong in my case.

      I've gone to the READ THIS FIRST section and I've set the TRACE logging for org.jboss.mq, org.jboss.logging.XLevel and org.jboss.logging.XLevel. I looked for any SQL related exception, and this is what I found:

      2005-02-24 17:13:58,578 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Resolving uncommited TXS
      2005-02-24 17:13:59,343 ERROR [STDERR] java.io.EOFException
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.DatabaseFile.readInteger(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Cache.makeRow(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Cache.getRow(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Table.setIndexRoots(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Table.setIndexRoots(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.processSet(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.execute(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.runScript(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.open(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database$Logger.openLog(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.open(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.openDB(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.run(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.main(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.jboss.jdbc.HypersonicDatabase$2.run(HypersonicDatabase.java:250)
      2005-02-24 17:13:59,343 INFO [STDOUT] Server.run/init: java.sql.SQLException: File input/output error: File input/output error: reading: java.io.EOFException in statement [SET TABLE JMS_MESSAGES INDEX '19640 8']
      2005-02-24 17:13:59,343 ERROR [STDERR] java.sql.SQLException: File input/output error: File input/output error: reading: java.io.EOFException in statement [SET TABLE JMS_MESSAGES INDEX '19640 8']
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Trace.getError(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.runScript(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Log.open(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database$Logger.openLog(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.open(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Database.(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.openDB(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.run(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.hsqldb.Server.main(Unknown Source)
      2005-02-24 17:13:59,343 ERROR [STDERR] at org.jboss.jdbc.HypersonicDatabase$2.run(HypersonicDatabase.java:250)
      2005-02-24 17:13:59,546 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection:
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused: connect)
      .
      .
      .

      I'm working exclusively with Queues and I'm persisting them in Hypersonic. I've read that the problem could be with durable subscriptions, is the procedure the same for Queues as it is for Topics?

      I truly appreciate any help I can get. I know that you might need more information regarding my configuration but I truly don't know what would be relevant and what wouldn't. Please let me know.

      Thank you.

      P.S. By the way, if I erase any reference to the JMS tables from the hypersonic scripts, I get a clean startup.