Two errors (see attachments):

Error #1.

select f from Food f where f.id = {color:red}(select fn.foodId from FoodName fn where (fn.name = :name or lower(fn.name) like :nameLowercase) group by fn.foodId){color} and (f.user.id is null or f.user.id = :userId or f.id = (select f2.id from Food f2, User u where f2.user.id = u.id and u.class = 'Sponsor'))

The above query is a valid one

Error #2.

select f from Food f where f.id = (select fn.foodId from FoodName fn where (fn.name = :name or lower(fn.name) like :nameLowercase) group by fn.foodId) and (f.user.id is null or f.user.id = :userId or f.id = (select f2.id from Food f2, User u where f2.user.id = u.id and u.{color:red}class{color} = 'Sponsor'))

Looks like IDEA don't like x.class !


Environment: EJB3

Issue was resolved