hi,
i have two tables with one to many relation. first table has composite key as primary key.

CandidatePositionAttachment table
PRIMARY KEY (candidateSeq, positionSeq, attachmentSeq)
FOREIGN KEY (attachmentSeq) REFERENCES CSS_Attachment

CSS_Attachment table
PRIMARY KEY attachmentSeq.

now how do I create mapping of one to many between candidatePositionAttachment and Attachment?

CandidatePositionAttachment.hbm.xml



is this correct? however it is not many to one mapping we have between these tables but it is one to many. and there is no key-one-to-many for this.

Requirement is to save multiple attachments for a given candidateId and positionId. using the above mapping, following code to save attachment for a given candidateId and positionId is giving null pointer exception when session.save is called. please point out what mistake i am doing.

Attachment videoAttachment = new Attachment();
CandidatePositionPK candidateJobPK = new CandidatePositionPK();
candidateJobPK.setCandidateSeq(1L);
candidateJobPK.setPositionSeq(1L);
candidateJobPK.setAttachmentSeq(videoAttachment);
CandidatePositionAttachment candidateJobVideo = new CandidatePositionAttachment();
candidateJobVideo.setId(candidateJobPK);
candidateJobVideo.setStatus("RECEIVED");
session.save(candidateJobVideo);

as of now, i have sorted it out, to insert a record in child table(attachment here) and then get the id of record, set it as primary key of candidate, position, attachment. save it.
i wish there is a better way to handle it in hibernate way of doing. but with composite keys it is not allowing me to map attachment as object. since its id won't be available, it fails while saving candidate position attachment.