Hibernate version: 2.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

Debug level Hibernate log excerpt:

Hi, I have a question about self-referential many-to-many mapping.

I have a table called Product and wish to model an association between a single product and other products. I am using an association table, ProductAssociates, with a foreign key of productId pointing to what I call the host product in the Product table, and the other key of associateId poiting to the other products in the SAME Product table. Thus the association table doesn't associate 2 separate entity tables, but rather 2 different values within the same entity table. I'm having trouble setting up the mapping for this in Hibernate. Can someone advise me on how to do this?
Hence Product A can have products B, C, D as associates.
Product D can have A, B, E as associates, etc.
Its a many-to-many mapping.

Thanks for your help in advance,
Femi

Sure, it would be collections on both sides of the association (many-to-many, right).

Product
---------------------------
PROD_ID
...


PRODUCTASSOCIATES
---------------------------
HOST_ID
ASSOCIATE_ID
...

This is helpful, thanks