It's not a secret anymore!
The moose likes Object Relational Mapping and the fly likes hibernate mapping Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernate mapping" Watch "hibernate mapping" New topic

hibernate mapping

Nital Chandel

Joined: Jun 20, 2008
Posts: 1
I have one Table1(parent table) which is having one primary key column (id) and two other columns (code_type and code_value) combination of both is unique.

Now another table Table2, which is a child table, has column (prob_type) which is referencing Table1 column (code_value), and NOT the primary key (id).

I dont think that there is any solution from DB point of view. Is there some property in Hibernate which I can use so that both the tables can be mapped or related through Hibernate mapping files?
Edvins Reisons
Ranch Hand

Joined: Dec 11, 2006
Posts: 364
A foreign key may reference any unique column(s) of the target table, and not necessarily the primary key.
I agree. Here's the link:
subject: hibernate mapping
It's not a secret anymore!