Hibernate version : 3

Database: MySQL 4.1

Problem:

Hi I am new to using Hibernate and I am not able to design a mapping document for the following scenario.

Facility_Table:
FacilityID, primary key
other fields

StateFields_Table:
FieldID, primary key
FieldName, varchar


Facility_State_Fields_Table (Association table)
FacilityID, primary key
StateFieldID, primary key
FieldValue, varchar

How should I create a mapping document to relate Facility table with the Facility_State_Fields_Table. If you see the tables, the fieldValue in the associate table is an extra field compared to the StateFields_Table.

Sorry if this is a lame question. But if someone can guide me, I will be very greatful.

Thanks in advance

Phani

Hi,

as far as I understood from the online documentation and the very good book "Hibernate in Action" you can model the association as a many-to-many association using a composite-element or (perhaps easier) define an entity class for your association and use two one-to-many associations.

In the latter case you would therefore have entity classes Facility, StateFields and FacilityStateFields.
Facility has a one-to-many association to FacilityStateFields and StateFields has a one-to-many association to FacilityStateFields.