Hi Team,
After creating a CDT properly, I am unable to verify Entity mappings in the data store. It is giving me the below error.
Note:- Record type is generated and synced with the table already available in the DB.
I want to keep my table name in uppercase [NT_NH_Handover_History] but during entity mapping i downloaded DDL, it is asking me to create a table with the name in lowercase ntnhhandoverhistory.
I have to keep the table name in upper case. Could you please suggest?
Discussion posts and replies are publicly visible
You would need to modify the XSD from the data type designer to modify the table name.
Please use this schema to define table name. the bold once will help you define table name
<xsd:schema xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types:MA" targetNamespace="urn:com:appian:types:NT"> <xsd:complexType name="NT_NH_Handover_History"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Table(name="NT_NH_Handover_History")</xsd:appinfo> </xsd:annotation> <xsd:sequence> <xsd:element name="id" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="id", nullable=false, unique=true, columnDefinition="INT")</xsd:appinfo> </xsd:annotation> </xsd:element>
</xsd:sequence> </xsd:complexType></xsd:schema>
Thanks,
It worked, I was missing the table name in XSD.