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

Parents

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

Reply

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

Children

No Data