I have a DB2 datasource and while mapping Appian datastore entities to the

ankitt over 9 years ago

I have a DB2 datasource and while mapping Appian datastore entities to the existing DB2 tables I am getting this error:
"The data source schema does not match the type mappings: Wrong column type in DB2ADMIN.EMPTABLE for column EMP_NUMBER. Found: char, expected: nvarchar(255) (APNX-2-4056-000)"

In my CDT there is a field "EMP_NUMBER" of type "Text" which I am trying to map to a column "EMP_NUMBER" of type "nvarchar"
In Appian we have only "Text" for all string type fields.
Is there any solution to this problem? ...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 9 years ago

<xsd:element name="ValidCredentials" type="xsd:string">
          <xsd:annotation>
                    <xsd:appinfo source="appian.jpa">
                              @Column(name="VALID_CREDENTIALS" columnDefinition="CHAR(1) NOT NULL")
                    </xsd:appinfo>
          </xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

<xsd:element name="ValidCredentials" type="xsd:string">
          <xsd:annotation>
                    <xsd:appinfo source="appian.jpa">
                              @Column(name="VALID_CREDENTIALS" columnDefinition="CHAR(1) NOT NULL")
                    </xsd:appinfo>
          </xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data