I am having trouble figuring out how to accomplish the following JOIN:

I have three tables, Device, DeviceFeature and Feature.

Device represents a physical hardware device. Feature contains features that a device may have. DeviceFeature contains the values for these features for each Device.

Example:



So, an example device would be:



and an example feature would be:



so, if I wanted to assign an IP address to device 1 (Server) I would have the following DeviceFeature record



The problem I am having is coming up with an efficient mapping in Hiberate. Ideally I want a Device to have a map of Features, with the key being Feature.Name and the value being DeviceFeature.Value (and have this map cascade to inserts, updates and deletes).

So far I have a Device mapping to a set of DeviceFeatures and each DeviceFeature maps to a Feature (this is a long painful traversal)

Any help you can provide would be appreciated.

Thanks,
Mark