File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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