1 Reply Latest reply: Apr 24, 2012 7:37 AM by Pfilion-Oracle RSS

    Eclipse JPA Error

    714362
      Hello,

      I have a question, my Eclipse Indigo, shows JPA errors, but there is no error (The Project is running on server without error)

      But I want to know why Eclipse reports an error:

      >
      The identification variable 'a' is not defined in the FROM clause.
      The identification variable 'b' is not defined in the FROM clause.



      My code:

      @Entity
      @Table(name="VERTICAL_SUIVI")
      @NamedQueries({
           @NamedQuery(name = "VerticalSuivi.findByAffaire", query = "Select a from VerticalSuivi a where a.verticalTableauDescriptifRe=:affaire"),
           @NamedQuery(name = "VerticalSuivi.findLastByAffaire",
                query ="select a from VerticalSuivi a where a.idsuivi = (select max(b.idsuivi) from VerticalSuivi b group by b.verticalTableauDescriptifRe having b.verticalTableauDescriptifRe=:affaire) AND a.verticalTableauDescriptifRe=:affaire")
      })

      Edited by: garfield335 on Apr 23, 2012 12:51 AM