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 Chris over 8 years ago

Hi durgeshk, we did annotate the column names with uppercase to match exactly which did not resolve the issue. Working with support now, it appears we may require a synonym matching the table name exactly, for both validation (Hibernate) and run time (Teneo) functionality to work properly (due to a Hibernate bug) - as the DB table is not in the Oracle user account default schema. Will report back once the solution has been verified.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris over 8 years ago

Hi durgeshk, we did annotate the column names with uppercase to match exactly which did not resolve the issue. Working with support now, it appears we may require a synonym matching the table name exactly, for both validation (Hibernate) and run time (Teneo) functionality to work properly (due to a Hibernate bug) - as the DB table is not in the Oracle user account default schema. Will report back once the solution has been verified.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data