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
3 replies
Subscribers
7 subscribers
Views
2018 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
When I import the attached schema to create a data type, and then verify mapping
pattye
over 10 years ago
When I import the attached schema to create a data type, and then verify mapping in a Data Entity, that works fine. However, when I try to query the table using a QueryEntity, I get an error ORA-00942 table or view does not exist. I think it is because the user that is connecting to the database is not the schema owner of the table I am trying to query. I tried adding the schema name into the @Table annotation, either this way, @Table(name="BPMS_AUTH_HISTORY", schema="ESOA"), or this way, @Table(name="ESOA.BPMS_AUTH_HISTORY"), but then when I try to verify mappings in the Data Entity, I get a mapping error that the table cannot be found. Is there a way to make this work in the annotation? Or is the only option to create a synonym for the database table? This is an Oracle database.
LoginAuthHistory.xsd
OriginalPostID-143965
OriginalPostID-143965
Discussion posts and replies are publicly visible
0
mathieud
over 10 years ago
I had the same bug as well. Schema name needs to be in lower case. Only known workaround is synonyms.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Durgesh
A Score Level 2
over 9 years ago
Even after providing schema name in lowercase in XSD file, still issue persists. Any other alternative to this issue?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
pattye
over 9 years ago
I ended up using synonyms.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel