Error "An identifier or literal is invalid" starting with JDBC 19c drivers (Doc ID 2720865.1)

Last updated on AUGUST 09, 2023

Applies to:

Symptoms

Error java.sql.SQLException: An identifier or literal is invalid
when executing queries using JDBC 19c drivers

This happens on queries which involve expressions containing double quotes and which do not have an alias.

When the resulting value is retrieved using the expression syntax as the column name the error may occur.

example:  The following will work with older JDBC drivers such as JDBC 11.2, 12.1, 12.2 or 18c but will fail with JDBC 19c

Cause

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