Uploaded image for project: 'Application Server 3 4 5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-2424

JMS PersistenceManager: ...Could not resolve uncommited transactions....java.sql.SQLException: Every derived table must have its own alias

    XMLWordPrintable

Details

    Description

      you are using mySQL 4.x as the persistence backend for JBossMQ

      After a restart, while the JMS persistence manager is attempting to recover uncommited txs, you might get the following exception

      2005-11-07 09:11:22,990 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed jboss.mq:service=PersistenceManager
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:416)

      Attachments

        Issue Links

          is related to

          Sub-task - The sub-task of the issue JBAS-2056 JMS_TRANSACTIONS constraint violation is not completely fixed

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              luc.texier Luc Texier (Inactive)
              luc.texier Luc Texier (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: