How to Define "BLOB" dataType of SQL in Appian CDT

mohammedz

Certified Associate Developer

over 8 years ago

Guyz,

I have a table in database with three columns
ID - Number
Document - BLOB
Name - VARCHAR

The Document column is of "BLOB" DataType....
Now I need to create a CDT and Map it to the Table
To do so what should be the dataType in my CDT or XSD Definition

Appreciate ur response....!!!!

Discussion posts and replies are publicly visible

Top Replies

ankitb0003 over 8 years ago +1

I have used the following definition for CLOB, It worked for me. it should be same for BLOB. <xsd:element name="DOCUMENT" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian…

Parents

0 ankitb0003 over 8 years ago

I have used the following definition for CLOB, It worked for me. it should be same for BLOB.

<xsd:element name="DOCUMENT" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="DOCUMENT", columnDefinition="CLOB")</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ankitb0003 over 8 years ago

I have used the following definition for CLOB, It worked for me. it should be same for BLOB.

<xsd:element name="DOCUMENT" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="DOCUMENT", columnDefinition="CLOB")</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data