Skip to Main Content
Forums

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01882: timezone region not found

Leandro LimaAug 22 2024

Hello folks.

As the title says, I'm hitting the ORA-01882 error, both on SQL Developer and SQLCL. Did some research and found many info about this situation and how this is a java problem rather than a database issue.

It was easy to find a solution for SQL Developer, just needed to add AddVMOption -Doracle.jdbc.timezoneAsRegion=false to the sqldeveloper.conf file and it worked like a charm.

Logically, since sqlcl is also based on java, this should be the same solution, right? Only problem is that sqlcl does not have a conf file.

I found an old post here in the forum (https://forums.oracle.com/ords/apexds/post/ora-01882-timezone-region-not-found-on-sqlcl-6634#comment_323462165725900199915802481891662801769) with the exactly same problem. But the solution is no longer applicable: the person added the -Doracle.jdbc.timezoneAsRegion=false option to a .bat file, but I believe the .bat file was ditched in favor of the actual exe nowadays.

I tried calling the sql.exe with the said option, but it does not work; It seems the compiled exe file does not accept java parameters as options?

So, Mr. Jeff Smith, any idea on how to solve this problem?
This post has been answered by Leandro Lima on Aug 22 2024
Jump to Answer

Comments

Leandro Lima
Answer

Oh well, I searched for a solution for about 2 hours and found nothing, then I decided to make this post here.

I kid you not, mere 10 minutes after posting my situation I just found a way to solve it. Now I'm feeling kind of silly and thought about deleting the post, but thinking twice I will let it here and provide the solution for someone else in the future (and because I don't know how to delete a post).

To make sqlcl use any additional JVM parameter, we need to set the JAVA_TOOL_OPTIONS variable with said parameter prior to invoking sql.exe:

SET JAVA_TOOL_OPTIONS=-Doracle.jdbc.timezoneAsRegion=false

Launching sql.exe afterwards connected normally.

More info here:

https://docs.oracle.com/en/database/oracle/sql-developer-command-line/20.2/sqcug/working-sqlcl.html#GUID-7AEF14E8-EA31-49A8-9A11-A9E765E2C7B6

Marked as Answer by Leandro Lima · Aug 22 2024
1 - 1

Post Details

Added on Aug 22 2024
#01882, #sqlcl, #timezone
1 comment
2,689 views