Hi All,
I have a MySQL table in which one of the fields has a TEXT datatype (char limit 65535). Unfortunately, the data I'm receiving for this field may exceed the char limit.
I've changed this field's datatype to (MySQL) MEDIUMTEXT (limit of 16Million), however, the field in the CDT for this table only provides TEXT type.
When I try to "Verify" my datastore, I get this error :
The data source schema does not match the type mappings: Wrong column type in [schema].[table] for column [field]. Found: mediumtext, expected: text (APNX-2-4056-000)
How can I fix/bypass this issue ?
Thanks in advance,
Regards,
Discussion posts and replies are publicly visible
Well, a few minutes more of searching by myself and I found the solution.
I downloaded the CDT's XSD, and added the following annotation to the field:
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(columnDefinition="mediumtext")</xsd:appinfo>
</xsd:annotation>
When I "verify" the datastore now, it's all fine.