These are chat archives for hibernate/hibernate-orm

Dec 2016
Lukáš Kováč
Dec 22 2016 12:20

Hello everybody, I'm trying to use this query (hibernate-entitymanager v3.5.6):

FROM CatchsEquipmentEntity AS e
JOIN e.catchs AS c
WHERE e.contractSubsystemSkey IN (1, 2)
AND c.yearMonth >= :dateFrom

But it returns 22 instances of CatchsEquipmentEntity instead of expected 2 instances (for Skey 1, 2) with loaded "catchs" collection (uni-directional OneToMany).. probably I'm missing something.. any suggestions?