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
7 subscribers
Views
5129 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 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>
....
OriginalPostID-237339
Discussion posts and replies are publicly visible
Parents
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
Reply
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
Children
No Data