0 Replies Latest reply on Sep 24, 2005 12:34 AM by David Vestal

    Every derived table must have its own alias

    David Vestal Newbie

      Windows XP

      JBoss 4.0.3RC2 installed via the installer program with "all" instead of minimal or ejb3.

      MySQL 4.1.14-nt-max via TCP/IP

      MySQL-Connector 3.1.10-bin

      I'm trying to get MySQL setup as my default database. I keep getting the same error when I use MySQL as the database for JMS. I do not get this error when it's configured for HSQLDB or using the null-persistence-service.xml file instead of mysql-jdbc2-service.xml.

      The error that I am getting is this:

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.mq:service=PersistenceManager
      State: FAILED
      Reason: 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)
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=DefaultDS
      Depends On Me:
      jboss.mq:service=DestinationManager



      I think the part that I can not figure out is the "Every derived table must have its own alias." At this point I'm stuck and have been trying to figure this out for a couple days. Feel free to ask for more information as I have no idea how much information on what is needed to fix this.

      Thank you for ANY possible help, even for a place to start looking.