ORA-01882: timezone region not found

[#1]

When try to use ExecuteSQL 1.25.0  to query  data from oracle 11g  , we received the below errors  can you guide me please , we have Apache NiFi in docker .

Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

[#2 · Accepted solution]

@ALWOSABY 

This looks related to the driver version you may be using in the processor.  Perhaps trying a different driver version may resolve you issue.  Perhaps try ojdbc6 version 11.1.0.7.0?

Please help our community thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt