My Oracle Support Banner

ORA-942 "Table Does not Exist" Error when Using JDBC 12.1.0.2 (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.

Symptoms


When attempting to run a JDBC application with JDBC 12.1.0.2 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 (12.1.0.2) 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. 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.