Hql Fetch: Condition on the right table

Question

1st question on StackOverflow !

In HQL I try to execute the following query :

    FROM Device d
    LEFT JOIN FETCH d.listNotifications l
    WITH l.dateLastSending BETWEEN :startDate AND :endDate"
    WHERE d.registerId=:registerId";

But getting following the error : "with-clause not allowed on fetched associations; use filters"

Filters looks a little bit complicated to me.

Is there any issue to set a condition on the right table ?

Regards

score 0 · Accepted Answer · answered Sep 12 '13 at 08:56

0

Remove FETCH clause.

(or try

FROM Device d
LEFT JOIN FETCH d.listNotifications l
WHERE (l.dateLastSending BETWEEN :startDate AND :endDate) AND (d.registerId=:registerId)

)

answered Sep 12 '13 at 08:56

Luca Basso Ricci

17,829
2
47
69

when removing the fetch the error Ljava.lang.Object; cannot be cast to com.site.project.model.Device – Maxime Sep 12 '13 at 09:09
you can't `FETCH` and use `WITH` togheter. dyd you try second query? – Luca Basso Ricci Sep 12 '13 at 10:29
1

Thank U Bellabax. I finally use @Filter as I had to deal with that with a single query. – Maxime Sep 16 '13 at 08:51

Hql Fetch: Condition on the right table

1 Answers1