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