Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
17 replies
Subscribers
5 subscribers
Views
7446 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
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 ?...
OriginalPostID-92697
OriginalPostID-92697
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