Hello Everybody, while mapping a CDT to a pre-existing MS SQL database I'm r

Jin Pheh

Certified Associate Developer

over 9 years ago

Hello Everybody, while mapping a CDT to a pre-existing MS SQL database I'm receiving an error: found char, expected nvarchar. Now usually I would just adjust the XSD type or add a column definition however both of those approaches have failed me in this instance.

I can't find anything that matches the data type in the documentation (forum.appian.com/.../Custom_Data_Types_from_XSD.html and setting the columnDefinition property of the @Column annotation doesn't appear to help.

Discussion posts and replies are publicly visible

Parents

0 Jin Pheh
Certified Associate Developer
over 9 years ago

My mapping is straight forward and included below - but yes, when I saw column definition I mean exactly that.

<xsd:element name="PrefLanguage" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="PreferredLanguage", columnDefinition="CHAR(4)")</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jin Pheh
Certified Associate Developer
over 9 years ago

My mapping is straight forward and included below - but yes, when I saw column definition I mean exactly that.

<xsd:element name="PrefLanguage" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="PreferredLanguage", columnDefinition="CHAR(4)")</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data