Hibernate version: 2.2

Looking for a place to get started on this one. I have three tables. People, Skills, and PeopleSkills. PeopleSkills is a table with a uniqueID, PeopleID, and a SkillID. So I figured I could:
Use a one to many relationship to get at the PeopleSkills table.... but then I need to do extra work to get at the name of the Skill (contained in the Skill table). So basically I need help, before I waste alot of time going down the wrong path.

What is the right way to set this up? any good examples on the web?

Sorry if this is a really newb question,
kellygreer1

Do you really need a PeopleSkill object, or is that just the collection table in a many-to-many relationship (see http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/collections.html#collections-ofvalues)? If PeopleSkills really is only a link, there is no need to make it a full-fledged object. However, if it does carry other information, then PeopleSkill can also carry a many-to-one relationship to Skill.

If you need to navigate from Skills back to People, you can also set up a "one-to-many-to-one" in the other direction.

OK. So I get the one-to-many and the many-to-one.
But I'm still missing something about the many-to-many thing.

Where is the middle table named?

Both the examples under many-to-many on this cheat sheet [1] only have one table named. Shouldn't you have to name 2 tables here? and 3 tables in total?

What am I missing?

[1] - http://ndpsoftware.com/HibernateMappingCheatSheet.html

Thanks for your patience.
kellygreer1

ok. I think I get it after reading:
http://www.theserverside.net/tt/article ... NHibernate

The example of the Department x Professors example is very good.
Made sense.

Thanks group,
kellygreer1