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 venkats533 over 11 years ago

I am very much familiar with the documentation you are referring to. The issue is that in my JPA annotations I have used all Capital Letters. Yet, the DDL generated has all Lower case letter AND quotes around each column name. The quotes is triggering case sensitivity and making Appian think the table does not exist. This is specific to Oracle
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 11 years ago

I am very much familiar with the documentation you are referring to. The issue is that in my JPA annotations I have used all Capital Letters. Yet, the DDL generated has all Lower case letter AND quotes around each column name. The quotes is triggering case sensitivity and making Appian think the table does not exist. This is specific to Oracle
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data