Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PGQL-Plugin for SqlCl produces error: java.sql.SQLSyntaxErrorException: ORA-00942: tbl/vw not found

BG4GRAPHNov 1 2021 — edited Nov 2 2021

Hi,
recently our graph server has been updated from version 21.3 to 21.4, sqlcl has been updated to 21.3 and the pgql plugin has been updated to 21.4.
Since then I can no longer execute pgql queries in sqlcl; I obtain the error "java.sql.SQLSyntaxErrorException: ORA-00942: table or view not found", even if only query translation is requested. (No trouble in the previous version.)
Which table or view is missing? The graph tables are there!

Thanks in advance for any hints,

BG4GRAPH.

PS: The plugin must be faulty. After downgrading the plugin to version 21.3 PGQL queries are running again. The prompt doesn't change when turning on pgql mode, though. I think I will make an SR.

This post has been answered by Hviehman-Oracle on Nov 5 2021

Jump to Answer

Added on Nov 1 2021

#database-key-features, #rdf-graph-property-graph

1 comment

190 views