wood burning stoves 2.0*
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
Author

hibernate mapping

Nital Chandel
Greenhorn

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.
 
Don't get me started about those stupid light bulbs.
 
subject: hibernate mapping