Hibernate version:v3


Can one sort objects by associations. Here is what I would like to do:

Person:
name
address

Visited Countries:
country name

One to many relationship between person and visited countries.

P1 visited --> {Italy, France}

P2 visited --> {India, US, Canada}

p3 visited --> {Canada}

p4 visited --> {France}

I would like to use HQL or Criteria APIs to sort persons by countries. Meaning I want the following results:

P3(Canada), P2(Canada, India, US), P4(France), P1(France, Italy)

All I need is a way to return people ordered by the countries they have visited.

Thanks