I am trying to map the CLOB data type with String in Appian CDT. But while trying to fetch data from query entity getting an error saying : an error occurred while retrieving data.
Below is the xsd mapping.
<xsd:element name="body_html" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="BODY_HTML", columnDefinition="CLOB")</xsd:appinfo> </xsd:annotation> </xsd:element>
Thanks.
Discussion posts and replies are publicly visible
community.appian.com/.../unable-to-query-clob-data-type-in-tempo
I've used CLOB as an Oracle database column in an Appian CDT several times and successfully. You may understand the error more clearly if you check the tomcat-stdOut.log in <APPIAN_HOME>/logs.
tomcat-stdOut.log
<APPIAN_HOME>/logs.