My Oracle Support Banner

java.io.IOException: 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 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

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: javax.net.ssl.keyStorePassword

.......

.......

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

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

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.