Delete Operation is not cascading When using Secondary Table

Rama Thummala

Certified Lead Developer

over 8 years ago

I am using single CDT mapping to two tables by using @Table and @Secondary Table.Insertion is working fine.
While Deleting the entity by passing primary key,the data is not getting deleted from DB.(org.hibernate.exception.ConstraintViolationException)
<xsd:appinfo source="appian.jpa">
                              @Table(name="emp")
                              @SecondaryTable(name="MoreInfo", pkJoinColumns=@PrimaryKeyJoinColumn(name="Id",referencedColumnName="empId"))
                    </xsd:appinfo>
.....
....
<xsd:element name="empId" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id</xsd:appinfo>
</xsd:annotation>
</xsd:element>
....

Discussion posts and replies are publicly visible

0 Arun Theja Muthyalu
Certified Lead Developer
over 8 years ago

@Ramanjaneyulu Thummala
Documentation says, "Any CDT created through the Data Type Designer or uploaded via an XSD file automatically has the cascade attribute to ALL by default, so unless you have manually changed this setting, deleting a parent record of a CDT with this setting results in the deletion of the parent's child records."
Please share what you are setting for "Data to Delete". Will try to help you based on that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Arun Theja Muthyalu
Certified Lead Developer
over 8 years ago

@Ramanjaneyulu Thummala
I can tell you a work around.
Try changing the Foreign Key Options. Set "On Delete" to "CASCADE" from MySQL Workbench.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rama Thummala
Certified Lead Developer
over 8 years ago

@Arun , Thanks for the response.

I could see,For nested CDTs by default cascade attribute value is ALL.But my case is with @SecondaryTable delete is not cascading.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Arun Theja Muthyalu
Certified Lead Developer
over 8 years ago

@Ramanjaneyulu Thummala
Okay. Any luck with the work around I have given?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 phanibabuk over 8 years ago

I suggest trying the option suggested by arunthejam to set the cascade option.

If we set "On Cascade" to Delete in the child foreign key constraint, then when a parent record is deleted, all the corresponding child records will automatically delete.

Also, tell me if you are trying to delete rows from one reference table or more than one?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rama Thummala
Certified Lead Developer
over 8 years ago

Thanks @Phani.
As a work around doing the soft delete,instead of actually deleting the record.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel