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.
select auth from Author join auth.books book where book = :book order by auth.lastName
select auth from Author auth join auth.books book where book = :book order by auth.lastName