Hibernate version:3.1.2
Database:Oracle 10g
Got a many-to-many with a link table containing 2 ids.
TableA (idA)
LinkTable (idA, idB)
TableB (idB, aDateField)
Trying to get A and all related B's but only where TableB.aDateField > passedInDate and for a particular idA.
I want to get A even if it contains no B's for the above criteria - so it would seem sensible to use an outer join.
I'm using the following criteria :
"from A a left outer join fetch a.B b where a.idA = 1 and b.aDateField > '14-Aug-06'".
I get nothing returned and suspect it's something to do with the link table.
Is it possible to do what I want ?
|