JPA2.0 CascadeType.ALL doesn't cascade persist

[Jelo Nehuptra]

I have the following code which doesn't cascade persist

    @EJB private PersonFacade examineeF;

    private Person examinee = new Person();
    private Person father      = new Person();
    private Person mother    = new Person();
    private Person guardian  = new Person();

    public void save() {
            examinee.setIdPerson1(father);
            examinee.setIdPerson2(mother);
            examinee.setIdPerson3(guardian);
            examinee.setExaminee(examResults);
            examineeF.create(examinee);
    }

Line 9-11 cascades ok but when it reaches line 12 it causes an error.


Person.java

    @OneToOne(cascade = CascadeType.ALL, mappedBy = "person", fetch = FetchType.EAGER)
    private Examinee examinee;

    @OneToOne(mappedBy = "idPerson3", fetch = FetchType.EAGER)
    private Person person;

    @JoinColumn(name = "ID_PERSON3", referencedColumnName = "ID_PERSON")
    @OneToOne(fetch = FetchType.EAGER, cascade= CascadeType.ALL) //***modified
    private Person idPerson3;

    @OneToOne(mappedBy = "idPerson1", fetch = FetchType.EAGER)
    private Person person1;

    @JoinColumn(name = "ID_PERSON1", referencedColumnName = "ID_PERSON")
    @OneToOne(fetch = FetchType.EAGER, cascade= CascadeType.ALL) //***modified
    private Person idPerson1;

    @OneToOne(mappedBy = "idPerson2", fetch = FetchType.EAGER)
    private Person person2;

    @JoinColumn(name = "ID_PERSON2", referencedColumnName = "ID_PERSON")
    @OneToOne(fetch = FetchType.EAGER, cascade= CascadeType.ALL) //***modified
    private Person idPerson2;

Examinee.java

    @JoinColumn(name = "ID_PERSON", referencedColumnName = "ID_PERSON", nullable = false, insertable = false, updatable = false)
    @OneToOne(optional = false, fetch = FetchType.EAGER)
    private Person person;

And I'm getting the following stack trace

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("LHS"."EXAMINEE"."ID_PERSON")
Error Code: 1400
Call: INSERT INTO LHS.EXAMINEE (ID_PERSON, CLASSIFICATION, EXAM_DATE, INCOMING, RPM, SATNR, SCAT, SEE_NO, SLU_GIT, SLU_NVIT, SLU_VIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [11 parameters bound]
Query: InsertObjectQuery(ph.edu.slu.lhs.sis.entity.Examinee[ idPerson=null ])
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)

[James Sutherland]

@OneToOne(cascade = CascadeType.ALL, mappedBy = "person", fetch = FetchType.EAGER)  
private Examinee examinee;  
   
@OneToOne(mappedBy = "idPerson3", fetch = FetchType.EAGER)  
private Person person;  

Your mappings do not make any sense. You have examinee mappedBy = "person" and person mappedBy = "idPerson3". You cannot have multiple mapped by, I think you meant to define PERSON_ID as the join column?

But perhaps include your schema.

[Jelo Nehuptra]

James Sutherland wrote:
But perhaps include your schema.

This is a part of my schema. The cascade persist works on the recursive relationship but not on the other relationship.
The code was generated by Netbeans7.1, i used the 'create entity classes from database'

[James Sutherland]

Oh, I see Examinee is a different class. Please include the code for it.

Where does examResults come from? Is it part of the persistence context? Is it new or existing, perhaps you need to merge it, or persist it separately.

Do you have a cyclic relationship? One of the foreign keys may need to be nullable to resolve a cycle, setting logging to finest will give some insight on what is going on.

[Jelo Nehuptra]

this is the code for the examinee class

public class Examinee implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    //@NotNull //***modified
    @Column(name = "ID_PERSON", nullable = false)
    private Long idPerson;
    @Size(max = 254)
    @Column(name = "SEE_NO", length = 254)
    private String seeNo;
    @Min(1)//***modified
    @Max(4)//***modified
    @Column(name = "INCOMING")
    private Short incoming;
    @Column(name = "EXAM_DATE")
    @Temporal(TemporalType.TIMESTAMP)
    private Date examDate;
    @Min(70)//***modified
    @Max(130)//***modified
    @Column(name = "SLU_GIT")
    private Short sluGit;
    @Min(70)//***modified
    @Max(130)//***modified
    @Column(name = "SLU_VIT")
    private Short sluVit;
    @Min(70)//***modified
    @Max(130)//***modified
    @Column(name = "SLU_NVIT")
    private Short sluNvit;
    @Min(70)//***modified
    @Max(130)//***modified
    @Column(name = "SCAT")
    private Short scat;
    @Min(70)//***modified
    @Max(130)//***modified
    @Column(name = "SATNR")
    private Short satnr;
    @Min(70)//***modified
    @Max(130)//***modified
    @Column(name = "RPM")
    private Short rpm;
    //@Size(max = 254)//***modified
    @Enumerated(EnumType.STRING)//***modified
    @Column(name = "CLASSIFICATION", length = 254)
    private Classification classification;
    @JoinColumn(name = "ID_PERSON", referencedColumnName = "ID_PERSON", nullable = false, insertable = false, updatable = false)
    @OneToOne(optional = false, fetch = FetchType.EAGER)
    private Person person;
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "idPerson", fetch = FetchType.EAGER)
    private Collection<Reservation> reservationCollection;

[Jelo Nehuptra]

James Sutherland wrote:
Where does examResults come from? Is it part of the persistence context? Is it new or existing, perhaps you need to merge it, or persist it separately.

I think it is coming from the same persistence context. When i persist the two entity classes together with their corresponding facades, it works, but when i try the cascade it doesn't.
How do i know if it is new or existing? the persistence context or the injected facade class?

this is the code for the injected '@EJB ExamineeFacade examResults;'

@Stateless
public class ExamineeFacade extends AbstractFacade<Examinee> {
    @PersistenceContext(unitName = "sisPU")
    private EntityManager em;

    @Override
    protected EntityManager getEntityManager() {
        return em;
    }
}

And the '@EJB PersonFacade person;'

    
@Stateless
public class PersonFacade extends AbstractFacade<Person> {
    @PersistenceContext(unitName = "sisPU")
    private EntityManager em;

    @Override
    protected EntityManager getEntityManager() {
        return em;
    }

[Jelo Nehuptra]

James Sutherland wrote:
Do you have a cyclic relationship? One of the foreign keys may need to be nullable to resolve a cycle, setting logging to finest will give some insight on what is going on.

I do have a cyclic/recursive relationship in the Person entity,
because of:
Person examinee;
Person father;
Person mother;
Person guardian;

If i will have the Examinee table to have the nullable foreign key, the 1 to 1 identifying relationship will be gone, thus, a examinee could have many examResults which shouldn't be.

I'll set the logging to finest, thanks for the advice.

[James Sutherland]

@JoinColumn(name = "ID_PERSON", referencedColumnName = "ID_PERSON", nullable = false, insertable = false, updatable = false)  
@OneToOne(optional = false, fetch = FetchType.EAGER)  
private Person person;

You have "insertable = false" on the foreign key, so if you did not set your basic idPerson field value, then it will be null. You need to set the idPerson field value.

You may also want to have insertable/updatable = false on the Id and true on the OneToOne, then it will pick up the value from the reference.

You could also remove the basic idPerson and just put @Id on the OneToOne.