Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/UserGuide/JPA/Advanced JPA Development/Schema Generation/CascadeOnDelete"
m |
m (Fixed link - apparently "latest" doesn't redirect to latest API anymore?) |
||
(14 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | ---- | ||
+ | |||
+ | |||
+ | '''[[Image:Elug_draft_icon.png|Warning]] This page is now obsolete. ''' | ||
+ | |||
+ | For current information, please see "@CascadeOnDelete" in the ''Java Persistence API (JPA) Extensions Reference for EclipseLink'': https://eclipse.org/eclipselink/documentation/2.5/jpa/extensions/a_cascadeondelete.htm | ||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
{{EclipseLink_UserGuide | {{EclipseLink_UserGuide | ||
|info=y | |info=y | ||
Line 5: | Line 19: | ||
|eclipselinktype=JPA | |eclipselinktype=JPA | ||
|api=y | |api=y | ||
− | |apis=[http://www.eclipse.org/eclipselink/api/latest/eclipse/persistence/annotations/CascadeOnDelete.html CascadeOnDelete] | + | |apis= |
+ | *[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/annotations/CascadeOnDelete.html @CascadeOnDelete] | ||
|examples=y | |examples=y | ||
|example= | |example= | ||
Line 12: | Line 27: | ||
= @CascadeOnDelete = | = @CascadeOnDelete = | ||
− | |||
− | |||
ON DELETE CASCADE is a database foreign key constraint option that automatically removes the dependent rows. | ON DELETE CASCADE is a database foreign key constraint option that automatically removes the dependent rows. | ||
− | Use the [http://www.eclipse.org/eclipselink/api/latest/eclipse/persistence/annotations/CascadeOnDelete.html <tt>@CascadeOnDelete</tt>] annotation | + | Use the [http://www.eclipse.org/eclipselink/api/latest/eclipse/persistence/annotations/CascadeOnDelete.html <tt>@CascadeOnDelete</tt>] annotation to specify that a delete operation performed on a database object is cascaded on secondary or related tables. |
− | {| cellpadding="2" border="1" | + | =====''CascadeOnDelete Behavior''===== |
− | + | {| cellpadding="2" border="1" cellspacing=0 | |
|- | |- | ||
− | | ''' | + | | '''Entity/Mapping''' |
− | | ''' | + | | '''Behavior''' |
|- | |- | ||
| Entity | | Entity | ||
Line 57: | Line 70: | ||
* Cascading : The remove operation should still be configured to cascade in the mapping if using CascadeOnDelete. | * Cascading : The remove operation should still be configured to cascade in the mapping if using CascadeOnDelete. | ||
− | + | == @CascadeOnDelete Example == | |
− | == | + | This example cascade the deletion of the Employee secondary table, and all of its owned relationships. |
<source lang="java"> | <source lang="java"> | ||
@Entity | @Entity | ||
Line 84: | Line 97: | ||
</source> | </source> | ||
− | == Specifying Cascade on Delete in orm.xml == | + | == Specifying Cascade on Delete in eclipselink-orm.xml == |
− | In the <tt>orm.xml</tt> descriptor file, specify cascade on delete as | + | In the <tt>eclipselink-orm.xml</tt> descriptor file, specify cascade on delete as shown in the following example: |
<source lang="xml"> | <source lang="xml"> | ||
<cascade-on-delete>true</cascade-on-delete> | <cascade-on-delete>true</cascade-on-delete> | ||
Line 93: | Line 106: | ||
See also, [[EclipseLink/Examples/JPA/DeleteCascade|DeleteCascade Example]] | See also, [[EclipseLink/Examples/JPA/DeleteCascade|DeleteCascade Example]] | ||
<br> {{EclipseLink_JPA | <br> {{EclipseLink_JPA | ||
− | |previous =[[EclipseLink/UserGuide/JPA/ | + | |previous=[[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Schema_Generation|Schema Generation]] |
− | |up | + | |up =[[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Schema_Generation|Schema Generation]] |
− | |next =[[EclipseLink/UserGuide/JPA/ | + | |next =[[EclipseLink/UserGuide/JPA/Advanced JPA Development/Schema Generation/Index|@Index]] |
|version=2.2.0 DRAFT}} | |version=2.2.0 DRAFT}} |
Latest revision as of 06:41, 7 May 2014
For current information, please see "@CascadeOnDelete" in the Java Persistence API (JPA) Extensions Reference for EclipseLink: https://eclipse.org/eclipselink/documentation/2.5/jpa/extensions/a_cascadeondelete.htm
EclipseLink JPA
EclipseLink | |
Website | |
Download | |
Community | |
Mailing List • Forums • IRC • mattermost | |
Issues | |
Open • Help Wanted • Bug Day | |
Contribute | |
Browse Source |
Key API
Examples
@CascadeOnDelete
ON DELETE CASCADE is a database foreign key constraint option that automatically removes the dependent rows.
Use the @CascadeOnDelete annotation to specify that a delete operation performed on a database object is cascaded on secondary or related tables.
CascadeOnDelete Behavior
Entity/Mapping | Behavior |
Entity | Defines that secondary or joined inheritance tables should cascade the delete on the database |
OneToOne mapping | The deletion of the related object is cascaded on the database.
This is only allowed for mappedBy/target-foriegn key OneToOne mappings (because of constraint direction). |
OneToMany mapping | For a OneToMany using a mappedBy or JoinColumn, the deletion of the related objects is cascaded on the database.
For a OneToMany using a JoinTable, the deletion of the join table is cascaded on the database (target objects cannot be cascaded even if private because of constraint direction). |
ManyToMany mapping | The deletion of the join table is cascaded on the database (target objects cannot be cascaded even if private because of constraint direction). |
ElementCollection mapping | The deletion of the collection table is cascaded on the database. |
@CascadeOnDelete has the following behavior:
- DDL generation : If DDL generation is used, the generated constraint will include the cascade deletion option.
- Entity : Remove will not execute SQL for deletion from secondary or joined inheritance tables (as constraint will handle deletion).
- OneToOne : If the mapping uses cascading or orphanRemoval, SQL will not be executed to delete target object.
- OneToMany : If the mapping uses cascading or orphanRemoval, SQL will not be executed to delete target objects.
- ManyToMany : SQL will not be executed to delete from the join table.
- ElementCollection : SQL will not be executed to delete from the collection table.
- Cache : Cascaded objects will still be removed from the cache and persistence context.
- Version locking : Version will not be verified on deletion of cascaded object.
- Events : Deletion events may not be executed on the cascaded objects if the objects are not loaded.
- Cascading : The remove operation should still be configured to cascade in the mapping if using CascadeOnDelete.
@CascadeOnDelete Example
This example cascade the deletion of the Employee secondary table, and all of its owned relationships.
@Entity @SecondaryTable(name="EMP_SALARY") @CascadeOnDelete public class Employee{ @Id private long id; private String firstName; private String lastName; @Column(table="EMP_SALARY") private String salary; @OneToOne(mappedBy="owner", orphanRemoval=true, cascade={CascadeType.ALL}) @CascadeOnDelete private Address address; @OneToMany(mappedBy="owner", orphanRemoval=true, cascade={CascadeType.ALL}) @CascadeOnDelete private List<Phone> phones; @ManyToMany @JoinTable(name="EMP_PROJ") @CascadeOnDelete private List<Project> projects; ... }
Specifying Cascade on Delete in eclipselink-orm.xml
In the eclipselink-orm.xml descriptor file, specify cascade on delete as shown in the following example:
<cascade-on-delete>true</cascade-on-delete>
See also, DeleteCascade Example