Column Names and Quotes in Oracle. I have an existing table with all column nam

venkats533 over 10 years ago

Column Names and Quotes in Oracle. I have an existing table with all column names in CAPITAL LETTERS. In my XSD, I gave UPPER CASE letters for column name. But Verify is failing when I am trying to add this entity into a data store. Appian is converting all column names to lower case and adding a quotes around them in DDL scripts. How to resolve this issue in Appian. In other words, how do I make Appian not to use quotes around column name or use the exact name in XSD ?...

Discussion posts and replies are publicly visible

Parents

0 venkats533 over 10 years ago

<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema
targetNamespace="appian.expressnet.redstone.gov/.../"
xmlns:types="appian.mms.vsak.com/.../" xmlns:xsd="www.w3.org/.../XMLSchema">
<xsd:complexType name="EXPRESS_NET_Users">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
           @Table(name="USERS")
</xsd:appinfo>
<xsd:documentation><![CDATA[Express Net Users]]></xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="UserName" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@Column(name="ID", columnDefinition="varchar(40)")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

           <xsd:element name="FirstName" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">

@Column(name="FIRST_NAME", columnDefinition="varchar(40)")
</xsd:appinfo>
                     <xsd:documentation>First Name of the User</xsd:documentation>
</xsd:annotation>
</xsd:element>

           <xsd:element name="LastName" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">

@Column(name="LAST_NAME", columnDefinition="varchar(40)")
</xsd:appinfo>
                     <xsd:documentation>Last Name of the User</xsd:documentation>
</xsd:annotation>
</xsd:element>

</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 10 years ago

<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema
targetNamespace="appian.expressnet.redstone.gov/.../"
xmlns:types="appian.mms.vsak.com/.../" xmlns:xsd="www.w3.org/.../XMLSchema">
<xsd:complexType name="EXPRESS_NET_Users">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
           @Table(name="USERS")
</xsd:appinfo>
<xsd:documentation><![CDATA[Express Net Users]]></xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="UserName" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@Column(name="ID", columnDefinition="varchar(40)")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

           <xsd:element name="FirstName" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">

@Column(name="FIRST_NAME", columnDefinition="varchar(40)")
</xsd:appinfo>
                     <xsd:documentation>First Name of the User</xsd:documentation>
</xsd:annotation>
</xsd:element>

           <xsd:element name="LastName" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">

@Column(name="LAST_NAME", columnDefinition="varchar(40)")
</xsd:appinfo>
                     <xsd:documentation>Last Name of the User</xsd:documentation>
</xsd:annotation>
</xsd:element>

</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data