Description Adrian Goerler 2010-05-10 08:39:38 EDT

I've got a one-to-one relationship between the entities Course and Material.

The relationship is annotated as follows:

@Entity
@Table(name = "TMP_COURSE")
public class Course {

...

    @PrimaryKeyJoinColumn
    @OneToOne(cascade = CascadeType.PERSIST, optional=true)
    public Material getMaterial() {
        return material;
    }

...

}

@Entity
@Table(name = "TMP_MATERIAL")
public class Material {

    ...

    @Id
    @Column(name = "COURSE_ID")
    public long getCourseId() {
        return m_id;
    }

    @OneToOne(mappedBy = "material")
    public Course getCourse() {
        return course;
    }


    @PrePersist
    public void prePersist() {
        m_id = course.getCourseId();
    }

    ... 

}

EclipseLink's forward mapper generates a FK constraint from TMP_COURSE to TMP_MATERIAL.COURSE_ID. The constraint is generated although the relationship is annotated as optional.

Inserting a Course without a Material fail with a FK constraint violation.