My Oracle Support Banner

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

Last updated on OCTOBER 21, 2020

Applies to:

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

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 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

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
Cause
Solution
References


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