Unable to cascade delete a @OneToOne member

Question

@Entity public class Organization {

    @OneToOne(fetch = FetchType.EAGER)
    @OnDelete(action = OnDeleteAction.CASCADE)
    @Cascade(value = DELETE_ORPHAN)
    private Days days;

}

I have the following entity definition and it generates a SQL to do a cascade delete on the @OneToOne entry when the parent object gets deleted. But it's not removing the "days" entry while deleting an Organization.

This happens with h2, mysql databases, what could be the problem here.

Answer 1

Well, I guess you should add a

@Cascade(value = {DELETE, DELETE_ORPHAN})

Note that in JPA 2.0 you don't have to use the hibernate-sepcific @Cascade annotation - @*ToMany has an option to delete orphans.

Update: when using queries cascades are not handled. You have to handle them manually. This is expected and documented behaviour.