HQL: matching collection

frer · **Joined:** Wed Jul 14, 2004 11:51 am **Posts:** 43

Hello,

I have a simple HQL question. I wish to build a query that will allow me to look for a child collection.

For example, I have a collection of kittens and wish to test which cats have these kittens.

I would like to be able to do something like this:

Code:

           String query = "select cat from Cat as cat join cat.kittens as kittens where kittens = " + cat.getKittens()");

How can I do this? Or is there another way?

Thank you

PS: if you also have an idea on how to do this in Criteria form, I'd be happy to know how

anthony · **Posted:** Fri Aug 13, 2004 12:52 pm

select kitten.cat from Kitten kitten where kitten = ???
this is easy but you need bidirectionnal one-to-many

frer · **Joined:** Wed Jul 14, 2004 11:51 am **Posts:** 43

Thanks for your reply,

Unforturately, I don't think you understood my problem. I have a Collection of Kittens and wish to match Cats that possess exactly those kittens.

For example, I have the Following Kittens (kit1, kit2, kit3). I want to match a Cat that has a child collection of exactly these 3 kittens (no more no less).

Thank you,

Fran