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

      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)

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

                Created:
                Updated:
                Resolved: