We're having an issue connecting to an Oracle database via data store. Our

Chris over 8 years ago

We're having an issue connecting to an Oracle database via data store. Our CDT is created, data store DOES map successfully, but when we run a query rule (or queryEntity) against the DS, we receive the error "ORA-00942: table or view does not exist". The CDT fields utilize annotations to remove underscores, but not sure what else could be the issue here. We have also tried connecting with and without schema "schema.table", but the DS only recognizes the table when schema is not included - however we cannot read data. Our DB account has correct permissions, this connection has been in production for years now - no changes there.

Has anyone else had this problem with Oracle, where the data store maps successfully but you cannot query data?

Discussion posts and replies are publicly visible

Parents

0 Durgesh
A Score Level 2
over 8 years ago

It may happen that, CDT fields are having different case (UPPER or LOWER) while naming than DB table column names. You can keep table column names in UPPER CASE (without putting in double quotes) and make CDT fields in UPPER CASE as well. See if that solves the issue. Let me know if you find anything else.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Durgesh
A Score Level 2
over 8 years ago

It may happen that, CDT fields are having different case (UPPER or LOWER) while naming than DB table column names. You can keep table column names in UPPER CASE (without putting in double quotes) and make CDT fields in UPPER CASE as well. See if that solves the issue. Let me know if you find anything else.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data