This discussion is archived
1 Reply Latest reply: Apr 24, 2012 5:37 AM by 342906 RSS

Eclipse JPA Error

714362 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points