I have a data model that I'm trying to map. I know how to do this if I'm using straight jdbc, but being new to hibernate I'm not real sure how to do it. Any help is greatly appreciated. What I have is something like this

site
-address, city, state, zip, etc

contact
-name, email address, etc

customer
-name (string)
-contact (Set of contacts)
-site (Set of sites)

===========
I have the above set up and working with reverse one-to-many mappings.

What I want to do is add something like

service-request
-id (unique id, straight forward)
-customer (customer)
-site (Site)
-contact (Contact)

the id is simple, just use the id element with some generator.
Now how do I get the correct behaviour for mapping the customer, site and contact? I would like a table like

service-request
-id (int)
-customer_id (int)
-site_id (int)
-contact_id (int)

is there any way to do this in hibernate? It's not a one to one mapping, a site/customer/contact can be associated with more than one service request. It's not a one-to-many mapping, each service request can only have one customer/site/contact. Is this a many-to-many mapping? Thanks in advance!!!
--m

I am assuming what you want in your java model is something like:


Then customer, contact, and site are each a many-to-one relationship. For example, a ServiceRequest can have only one Customer, but a customer can have many ServiceRequests.

Map the above like: