Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Post Details

Added on Nov 1 2021
#database-key-features, #rdf-graph-property-graph
1 comment
146 views