Hi,

Following from the hibernate examples, let's say I have a list of Cats each containing a list of kittens with the date they were born (column "born" on kittens table) and their name. Let's say I want to query all Cats that have a kitten where I want to check that only the last Kitten born has a name equals to "Mimi"

This is what I thought would work but doesn't:



Any ideas are greatly appreciated!

Thanks, Jason[/code]

I think you need to turn the order around:



Otherwise the "name" restriction will apply to the Cat, not the kitten. Not 100% sure but i had some problem like this a while ago.
Also it should be setMaxResults instead of setMaxOrder but i guess that was a typo