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 Composite key mapping Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Composite key mapping" Watch "Composite key mapping" New topic

Composite key mapping

Pallu Sagar

Joined: Dec 04, 2009
Posts: 16
I have Composite Primary key and foreign key which is also composite key. one of the column is same...

i.e. Table Group has composite Id PRIMARY KEY(gId, cId) [ Where cId is primary key of other table ]

Now Table GroupMember has composite primary key PRIMARY KEY(gmid, cId ) [ Where cId is primary key of other table ].

GroupMember also has foreign key fkgroup REFERENCES Group(gid, cId) (which is composite key as mentioned above]

Now, when I attemt to save GroupMember instance, foreign key (fkgroup) is not inserted. In many-to-one relationship I cannot set insert=true because cId is part of primary key for both GroupMember and Group Table.

How do I persist column fkgroup of GroupMemeber table?

I agree. Here's the link:
subject: Composite key mapping
It's not a secret anymore!