Hi, I'm trying to figure out a reasonable manner to query on 1:M mapped releationship ojbects.. or if its possible at this time.
I have two objects.. say something like a Detail object with detailId and detailName, and a Master object that references a collection (Vector) of details associated with itself. If I wanted to retrieve all Master objects with a specific detail name, how would I go about that? For example: select * from org.lemur.ojb.Master where details.detailName='foo' order by masterId When I try a sub-selection, I get a null error from the generated sql.. specifically, it munges the inner join SQL on the second table assignment: SELECT A0.masterId,A0.foo FROM masters A0 INNER JOIN null A1 ON.... So, is it possible to query in this manner? If not, what is a good way to query collections/relationships with the current system? thanks, paul
