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
7 replies
Subscribers
9 subscribers
Views
6951 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
CDT Mapping Primary Key and Foreign Key
Ravi Roshan
over 8 years ago
I have a main table say ABC which has ID column as primary and identity. I have another table DEF where I have another column say CASE_ID which is both primary and foreign key but not the identity. In the second table DEF I have provide the reference as ABC.ID.
I have mapped the second table CDT DEF in CDT ABC, however while verifying the Data Store, I am getting the error "The data source schema does not match the type mappings: Missing column: CASE_ID in dbo.ABC (APNX-2-4056-000)"
My Requirement is to map the second table as @OneToOne Relationship with first table. Please find some screenshots for reference in attachment.
Please provide any solution for this. Thanks
OriginalPostID-261496
Discussion posts and replies are publicly visible
Parents
0
Puspendu Pal
over 8 years ago
I think the error is because you are missing the referencedColumnName="ID" in the @JoinColumn annotation. The system assumes the referenced column name as the same name if referencedColumnName is not specified.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Puspendu Pal
over 8 years ago
I think the error is because you are missing the referencedColumnName="ID" in the @JoinColumn annotation. The system assumes the referenced column name as the same name if referencedColumnName is not specified.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data