ORA-942 "Table Does not Exist" Error when Using JDBC 220.127.116.11
(Doc ID 2978514.1)
Last updated on OCTOBER 03, 2023
Applies to:JDBC - Version 19.10 and later
Information in this document applies to any platform.
When attempting to run a JDBC application with JDBC 18.104.22.168 connecting to Oracle Database 19.3, the following error occurs.
Having an application running in Kubernetes using JDK 1.8 and connecting to Oracle database 19.3 using JDBC ojdbc7 (22.214.171.124) results in the following behavior. The issue is that at runtime, the SQL statement "SELECT <CULUMN> FROM SCHEMA.TABLE" for some reason gets changed by removing the " ." after the schema and the table name is combined with the schema which makes it non-existing table in the database; hence the error "ORA-942 table does not exist" occurs.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document