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

Composite key mapping

Pallu Sagar
Greenhorn

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?


-Sagar
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Composite key mapping
 
Similar Threads
[Help] Hibernate composite key plus foreign key with cascade insert.
database design help needed
Hibernate many-to-one composite key as foreign key
Composite Primary key and JDBC
Hibernate Mapping- composite id (pk+ foreign key)