Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.2

Mapping documents:

Name and version of the database you are using:
MySQL 5.0.41

Debug level Hibernate log excerpt:

Dear Team,

This question may be best in Hibernate forum. I use appfuse 1.9.4 with WW2. My problem is,

There is City field in user table, some users are in big cities like LA, San Francisco and others in not well-known cities. I also have a city table containing records of most big cities with its state.
On JSP page, I want list user by city: LA, San Francisco, Other (all other cities in CA).

How can I create a map/set in Hibernate?
1) Get set1 of city list in the state from city table
2) Get all users whose city is *not* in above set1

I think Hibernate or MySQL should have a way, but I don't know. Maybe one way is to ask:)
Thanks a lot in advance!
-Bruce