Hi all,
We are running into a strange issue.
We wanted to map a database column of type char(50) into a Appian string.
<xsd:element name="weekView" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="weekView" , columnDefinition="CHAR(50)" , length=50)</xsd:appinfo>
</xsd:annotation>
</xsd:element>
DB Column Definition:
CHAR(50 CHAR) [This does not work. This is the output of a view defined by DB team.]
VARCHAR2(255) [The output having varchar2(255) works but the output containing char(50 char) does not work. Even CHAR(1) works.]
How can I map char(50 char) to a Appian type.
Thanks...
Discussion posts and replies are publicly visible
Did you try using the map from existing object feature?When I map to an existing object with a CHAR(50) field, I get
type:"xsd:string"@Column(name"colB", columnDefinition="CHAR(50)")
Hi ChristineH,
Good day.
I already tried this option but strangely it doesn't work.