ORA-01882: timezone region not found

ALWOSABY — Mon, 01 Apr 2024 10:17:13 GMT

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

Re: ORA-01882: timezone region not found

MattWho — Mon, 01 Apr 2024 13:48:25 GMT

@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

question Re: ORA-01882: timezone region not found in Support Questions

ORA-01882: timezone region not found

Re: ORA-01882: timezone region not found