Create Foreign key ON UPDATE CASCADE in JPA (eclipselink)

Question

I am using CascadeType.MERGE but the generated sql does not contain any ON UPDATE in the foreign key. Here is my code

@Entity
public class Address {
    @Id
    private int id;

    private String address;
}

@Entity
public class Employee {
    @Id
    private int empId;

    @OneToOne(cascade = CascadeType.MERGE)
    private Address address;
}

Is there anything missing here

score 1 · Accepted Answer · answered Aug 13 '12 at 15:27

1

CascadeType.MERGE is a JPA construct that tells the provider what when you call merge on Employee to also call merge on the referenced Address.

ON UPDATE CASCADE is a database setting that doesn't seem to have anything to do with CascadeType.merge. It causes the database to update foreign keys if the referenced primary key changes. Since changing primary keys in JPA is not allowed, this setting doesn't make sense. It is recommended you use sequencing for unique identifiers if you have a natural pk that might need to change.

answered Aug 13 '12 at 15:27

Chris

20,138
2
29
43

I have been trying to find where it says primary keys cannot change in the JPA specification. Do you have a reference to this? – Namphibian Sep 17 '12 at 12:43
The answer in this [link](http://stackoverflow.com/a/2217064/2499238) references the JPA specification. – Martin Woolstenhulme Jan 05 '15 at 18:26

Create Foreign key ON UPDATE CASCADE in JPA (eclipselink)

1 Answers1