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

    XAConnectionFactory not bound on Startup

    ccsdev

      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.

        • 1. Re: XAConnectionFactory not bound on Startup
          ccsdev

          Here is some additional information regarding our Queues and configuration. We're using Jboss 3.2.3. We do not use the jbossmq.xml file, we use an xml file which is located in the deploy directory with entries such as the following:



          <depends optional-attribute-name="DestinationManager">jboss.mq:service=DestinationManager



          If you need any more information please let me know. Any help will be appreciated.

          • 2. Re: XAConnectionFactory not bound on Startup

            Moderated: FAQ (actually two of them)

            • 3. Re: XAConnectionFactory not bound on Startup
              ccsdev

              I'm truly sorry Adrien, but the only FAQ that I found was http://www.jboss.org/wiki/Wiki.jsp?page=IGetXAConnectionFactoryNotBoundHowDoIFixIt I did everything stated in the "READ ME FIRST" section which is where this directs you to go, and I get the error that I posted in the original message. This means that I did it before I posted.

              Regarding the second part in the FAQ, where it states:

              Check if you have deleted "hsqldb-jdbc2-service.xml" and make sure tables used by jboss system support transaction, i.e. change type of database table from "MyISAM" to "InnoDB".
              , I still have my "hsqldb-jdbc2-service.xml" file and, pardon my ignorance, but I have no idea what you mean by "MyISAM" and "InnoDB".

              I tried the fixed "concurrent.jar" found in JBoss_3_2_4_RC2, and now I can start and restart my server with no exception, but I don't know for sure if this will be enough. I would appreciate if you could give me more information on the subject. I would like to know if this is merely a workaround or if this solves my problem.

              Thanks again for your help.

              • 4. Re: XAConnectionFactory not bound on Startup
                ccsdev

                Ok, now that I've read a little bit about InnoDB I must reiterate that I'm using Hypersonic. Given the case, is this point still relevant?

                • 5. Re: XAConnectionFactory not bound on Startup
                  ccsdev

                  Please! I truly need your help. I thought the concurrent.jar solution had worked. The truth is that sometimes it works and sometimes it doesn't.

                  I would truly appreciate any help you could give me. Please.