Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
5 subscribers
Views
4812 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Delete Operation is not cascading When using Secondary Table
Rama Thummala
Certified Lead Developer
over 7 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>
....
OriginalPostID-237339
Discussion posts and replies are publicly visible
Parents
0
phanibabuk
over 7 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 7 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