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?