Hi, I am trying to map a composite key from a different CDT to another one

aswinb608

A Score Level 2

over 8 years ago

Hi,
I am trying to map a composite key from a different CDT to another one using one unique key inside xsd. How do I do it? Two columns from one cdt form a composite pair and I have another foriegn key coming from that table which defines the relationship. I want to map this foriegn key to that parent table inside CDT. What all JPA annotations should I use to get this behavior. I tried my best looking up online and troubleshooting with various things like @EmbeddedId, @Embeddable,@XmlInverseReference(mappedBy="fk_key")....but none of them parsed through appian cdt parser. Any help would be deeply appreciated.

Discussion posts and replies are publicly visible

Parents

0 ChristineH
Certified Lead Developer
over 8 years ago

You need to map the @ID to a real column in the table or view and it can only map to one column. If your table does not have a unique column, one idea is to create a view that has a viewID column. That column can be a concat of the two columns with a separator in between (as 111 is not the same as 1_11 or 11_1). Then use this column as the @ID.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 8 years ago

You need to map the @ID to a real column in the table or view and it can only map to one column. If your table does not have a unique column, one idea is to create a view that has a viewID column. That column can be a concat of the two columns with a separator in between (as 111 is not the same as 1_11 or 11_1). Then use this column as the @ID.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data