@OracleIMC Partner Resources & Training: Discover your Modernization options + Reach new potential through Innovation

JDeveloper 12c – ORA-01882: timezone region not found

Very often when developing Oracle ADF
in Oracle JDeveloper
, one needs to connect to a database.

Depending on the Oracle Database version you are
trying to connect to, you will sometimes hit the following bug/error (in my
case Oracle Database

The solution to this is to use a timezone supported by the database. This can be done
by setting the TZ environment variable. When TZ is set, its value will be used
rather than the operating system default timezone. You can find the solution for
Developer/Data Modeler
in the Oracle Community here

The workaround is to set the connection property oracle.jdbc.timezoneAsRegion
to "false". This reverts to the old style of session timezone

      - Right-click the connection, and select “Properties

Select “JDBC

 -  - Click “Green plus sign” to add a parameter.

-     - If “oracle.jdbc.timezoneAsRegion”
is not available in the “Name” drop-down
list. You can type in the “Name”,
and enter the “Value” as “false”

- Click “Ok”
to accept the changes, and this will take you back to the “Edit Database Properties”.

-     -  Click “Test
, and this should get a “Success!”

Facebook Google+ Twitter LinkedIn Pinterest Delicious Digg Addthis

Join the discussion

Comments ( 1 )
  • ronal Friday, March 22, 2019
    set EXTRA_JAVA_PROPERTIES=-Duser.language=en -Duser.country=US %EXTRA_JAVA_PROPERTIES%

    EN este archivo .- C:Userscjimenez.DGSGIFAppDataRoamingJDevelopersystem12.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.