help me with mapping

[sam bartl]

I have a table

EA_MPF(
SYS_MPF_ID,
SYS_AUDIT_PROG_ID,
SYS_FINDING_ID
)
EA_MPF_NON_LEAD_PROGS(
SYS_MPF_ID,
SYS_AUDIT_PROG_ID
)

EA_AUDIT_PROGRAM(
SYS_AUDIT_PROG_ID,
...
..
..
)

here is the entity for EA_MPF table

@Entity
@Table(name = "EA_MPF")
public class MultiProgramFinding  {
	
	private Long  sysMPFId ;
	
	private EaAuditProgram  leadAuditProgram;
	
	private StgFinding  finding;
	
	private Set<EaAuditProgram>  nonLeadPrograms= new HashSet<EaAuditProgram>();

	@Id
	@GenericGenerator(name="ea_mpf_seq", strategy="sequence", parameters = {
            @Parameter(name = "sequence", value = "EA_MPF_SEQ"),
            @Parameter(name = "unsaved-value" , value = "null"),
            @Parameter(name = "allocationSize", value = "1")
    })
	@GeneratedValue(generator="ea_mpf_seq")
	@Column(name = "SYS_MPF_ID")
	public Long getSysMPFId() {
		return sysMPFId;
	}

	public void setSysMPFId(Long sysMPFId) {
		this.sysMPFId = sysMPFId;
	}
	
	
	@OneToOne(optional=false,fetch=FetchType.LAZY)
	@JoinColumn(name = "SYS_AUDIT_PROG_ID", nullable = false)
	public EaAuditProgram getLeadAuditProgram() {
		return leadAuditProgram;
	}

	public void setLeadAuditProgram(EaAuditProgram leadAuditProgram) {
		this.leadAuditProgram = leadAuditProgram;
	}

	@OneToOne(optional=false,fetch=FetchType.LAZY)
	@JoinColumn(name = "SYS_FINDING_ID", nullable = false)
	public StgFinding getFinding() {
		return finding;
	}

	public void setFinding(StgFinding finding) {
		this.finding = finding;
	}

	@OneToMany(cascade=CascadeType.ALL)
	@JoinTable(
			name = "EA_MPF_NON_LEAD_PROGS",
			joinColumns = {@JoinColumn(name = "SYS_MPF_ID")},
			inverseJoinColumns = {@JoinColumn(name = "SYS_AUDIT_PROG_ID")}	
	)
	public Set<EaAuditProgram> getNonLeadPrograms() {
		return nonLeadPrograms;
	}

	public void setNonLeadPrograms(Set<EaAuditProgram> nonLeadPrograms) {
		this.nonLeadPrograms = nonLeadPrograms;
	}
	
	
}
 

Entity for EA_AUDIT_PROGRAM is pojo with all getter and setter methods called EaAuditProgram

Entity MultiProgramFinding has a leadEaAuditProgram and nonLeadEaAuditPrograms both these properties are mapped to EaAuditProgram , in order to have bidirectional relation in EaAuditProgram I have to map MultiProgramFinding twice , is this how I should map or is there a better way please advice me ?
also I posted this question in spring forums.

[Vijitha Kumara]

in order to have bidirectional relation in EaAuditProgram I have to map MultiProgramFinding twice...

How have you mapped this in "EaAuditProgram", can you show that part of the code? What's the issue you are having if it's not working?

[sam bartl]

Vijitha Kumara wrote:

in order to have bidirectional relation in EaAuditProgram I have to map MultiProgramFinding twice...

How have you mapped this in "EaAuditProgram", can you show that part of the code? What's the issue you are having if it's not working?

I haven't mapped yet and I dont have any issue, what I am asking is whether it is nice desing to map an entity twice in other entity in mycase in eaAuditprogram I have to map MultiProgramFinding twice , I am asking suggestions if this can be done in a better way ?

[Vijitha Kumara]

...what I am asking is whether it is nice desing to map an entity twice in other entity

If the business problem wants it that way or you cannot avoid it then you have no choice. But that may solely depends on the problem and the design you have.