In JPA, you cannot use aliases for FETCH JOINs. Remove FETCH and your query should work.

Regards,
Harald

Am 30.06.2011 13:40, schrieb mpf:
Hi!
I tried following:

SELECT p
FROM Person p LEFT JOIN FETCH p.fruehereNamenListe f
WHERE ( LOWER(p.nachname) LIKE :nachname OR LOWER(f.nachname) LIKE
:fNachname )


Does Alias dont work wir LEFT JOINS? Bug? Or did I something wrong?

Reply via email to