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

venkats533 over 11 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 Patty Isecke
Appian Employee
over 11 years ago

You can use JPA annotations in your XSD files to define tables and column names, as well as other attributes that require specific parameters or as in your Oracle database to create schemas, tables that are case sensitive.
Check out: forum.appian.com/.../Defining_a_Complex_Data_Type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Patty Isecke
Appian Employee
over 11 years ago

You can use JPA annotations in your XSD files to define tables and column names, as well as other attributes that require specific parameters or as in your Oracle database to create schemas, tables that are case sensitive.
Check out: forum.appian.com/.../Defining_a_Complex_Data_Type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data