1 Reply Latest reply on Jan 24, 2008 8:58 AM by jaikiran pai

    What is wrong with this query?

    Hussein Baghdadi Novice

      Hi.
      I'm using Hibernate as a persistence provider framework and JPA annotations to map domain classes to the database.
      I have two classes:
      Author and Book and the relationship is many-to-many.
      I defined this names query:
      [CODE]@NamedQuery(name = "findAuthorsByBook",
      query = "select auth from Author join auth.books book where book = :book order by auth.lastName")
      [/CODE]
      IntelliJ is telling me that there is something wrong with this query but I'm not convinced to run a SeamTest to try it.
      I got a HibernateException (IntelliJ was right after all).
      Whats wrong with HQL?
      Thanks.