i've combed through the documentation, but i'm having a problem that i'm still unclear about.

i have a few mapped objects:



as you can see, B links objects A and C together (there is a bunch more metadata in B that i'm not including for brevity).

what i've been trying to do is to issue a query along the lines of (this is in "psuedo-query", and not in HQL or SQL)

'find all the As where A.[/code]

(sorry - i entered the message before finishing it)

i would like to issue a query along the lines of

'find all the As where A.AToBLinks.C.name = "foo" and A.AToBLinks.C.Name = "bar"'

as there can be many C objects hung off the A objects (through a B link), i'm looking for all the A objects which have (implicitly) more than one C object associated to it, and where one of the objects has a name property of "foo" while another one of the objects has a name property of "bar".

can somebody please point me how to create a HQL query that will do that? also, if you can show me how to build a Criteria object that also does it (if that is even possible), i will be really appreciative.

select distinct b.A from B as b where b.C.name = 'foo' or b.C.name = 'bar'

thank you so much - that's brilliant, it didn't occur to me to select on the link instead. is it possible to translate that type of query to Criteria objects (i'm not sure i entirely understand how as the select is being done on a different object than one being returned), or should i have my application simply (but carefully) build the HQL query instead?

There should not be any issue geting the critera API to work with this. Having said that I just don't use it all that much so I am a bit rusty. HQL feels quite natural to me. Anycase, with H3.x improvements its a much more attractive API and I can see myself exploring it further.