X

@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
12c
, 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
XE
)

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
SQL
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
behavior.

      - Right-click the connection, and select “Properties

Select “JDBC
Parameters…”

 -  - 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
Connection”
, 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%
    set JAVA_PROPERTIES=%JAVA_PROPERTIES% %EXTRA_JAVA_PROPERTIES%

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