I'm trying to follow the instructions from the faq

How do a write a query that returns objects based upon a WHERE clause condition applied to their collection elements?

select distinct parent
from Parent parent,
join parent.children child
where child.name = :name



First off, the comma seems to be causing a problem


Second this doesn't work when the collection is mapped using
composite-element
I get the following error:
net.sf.hibernate.QueryException: collection of values in from clause: solohawb0_.notes.elements [select distinct hawb from kls.domain.entity.solo.SoloHawb hawb join hawb.notes note where note.type = :type]


However it does seem to work when the collection is mapped
using one-to-many

Do I have to use on-to-many?
I'd prefer to use a composite-element
as the collection is really of value objects and not of entities

Get rid of it, it is a mistake.




Get Hibernate 2.1 beta.