Hibernate version:
2.1.3
Mapping documents:
N/A
Code between sessionFactory.openSession() and session.close():
N/A
Full stack trace of any exception that occurs:
N/A
Name and version of the database you are using:
HSQL
The generated SQL (show_sql=true):
N/A
Debug level Hibernate log excerpt:
N/A

Can anyone point me at a good example of a way to map a many to many as well as a query between 2 classes (say Foo and Bar) that encompasses the following features:

1. Foo and Bar both have single column ID's
2. There is an association table FooBar that has extra columns that need to be mapped
3. The association class FooBar is using a composite ID with a seperate key class
4. The query needs to find all Foo instances such that they contain a given Bar

I've tried so many different ways of doing this I've lost track. Surely there should be some example code somewhere that shows this?

This test case for Hibernate3 should help give you some idea:

http://cvs.sourceforge.net/viewcvs.py/h ... /test/cid/

(Note, however, that doing the same thing in HB2 is not quite identical.)

Thanks, those examples helped a lot.

I don't think I quite had the concept of mapping the columns as properties in the key versus mapping the entities in the many to many class. Once I had that figured out the query became much easier.