My Oracle Support Banner Environment variable is not set: ORACLE_HOME. ('?' is interpreted as $ORACLE_HOME) (Doc ID 2863302.1)

Last updated on APRIL 21, 2022

Applies to:

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


Trying to connect to an ATP Database using JDBC thin driver fails with the below error

Cannot get Connection from Datasource: java.sql.SQLException: the connection properties file contains an invalid expression in the value of:



Caused by: Environment variable is not set: ORACLE_HOME. ('?' is interpreted as $ORACLE_HOME)
at oracle.jdbc.driver.PropertiesFileUtil$Interpreter.readQuestionMark(
at oracle.jdbc.driver.PropertiesFileUtil$Interpreter.interpret(
at oracle.jdbc.driver.PropertiesFileUtil.processExpressions(

The wallet password contains "?" in it. An example password is "test_?cd_194" and the program reads it from the .properties file

Because of the"?" character it fails with the above error. No issues without the character "?"


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.