Hibernate version: 3

Name and version of the database you are using: Oracle 10g

I have a class Cat with a collection of Kitten objects. I'm trying to perform a select on Cat with a distinct on Cat.kittens.id. The idea is that my HQL will return only the first Cat object that contains a specific kitten.

For instance:

Table: CAT
id | name
_________
0 kenny
1 stan
2 kyle

Table: KITTEN
id | name
____________
0 grumpy
1 sleepy
2 dopey


Table: CAT_KITTEN_XREF
cat_id | kitten_id
_____________________
0 0
0 1
1 1

I would see Cats 0 and 2 returned. Cat 1 would not be returned because it contained a matching kitten with Cat 0 (Kitten 1).

Does anyone know if this can be done via HQL?