My Oracle Support Banner

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

Last updated on AUGUST 09, 2023

Applies to:

JDBC - Version 19.3 and later
Information in this document applies to any platform.


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



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

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