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
4809 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
Arun Theja Muthyalu
Certified Lead Developer
over 7 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
Reply
0
Arun Theja Muthyalu
Certified Lead Developer
over 7 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
Children
No Data