Forum Stats

  • 3,770,911 Users
  • 2,253,180 Discussions


How to fix msg=ORA-01882: timezone region not found

676629 Member Posts: 1
edited Sep 15, 2011 5:00AM in JDeveloper and ADF
Im new in ADF development and I have this problem, I have a error message: (oracle.jbo.JboException) JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-01882: timezone region not found

I dont know how to fix it, please help me.



  • hofespet
    hofespet Member Posts: 597

  • 549039
    549039 Member Posts: 175
    put "-Duser.timezone="+02:00" into java arguments of the project
  • I had same error and solved by this way

    1. Go Tools > Project Properties then

    2. (Project Properties) open select Run/Debug/Profile > in right you will see Default > Double click here or click Edit
    3. (Edit run configuration) select Launch Settings > in 'Java option' text item past this line -Duser.timezone="+06:00"
    4.close and re-open JDeveloper
    5. Run entire project

    Good Luck!

  • 575792
    575792 Member Posts: 68
    I am getting same problem but i want to deploy my application in stand alone WLS,

    and running configuration didnt work for me... isnt a way to fix java time zone?

    I am using windows server 2003
    jdeveloper and weblogic 10.3.1
    ADF application
  • 719931
    719931 Member Posts: 24
    Hi all

    I am using jdev11g (with weblogic), i faced same issue and included -Duser.timezone as mentioned in default run target, but still got the same error.

    WARNING: ADF: Adding the following JSF error message: ORA-01882: timezone region not found

    java.sql.SQLDataException: ORA-01882: timezone region not found

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(
    at oracle.jdbc.driver.DatabaseError.newSQLException(
    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4C8Oall.receive(
    at oracle.jdbc.driver.T4CStatement.doOall8(
    at oracle.jdbc.driver.T4CStatement.executeForRows(

    I am new to ADF and trying to create ADF Table from Database Table using Entity and View Objects.

  • 236803
    236803 Member Posts: 39
    When you try to run an application deployed on a weblogic server (with a datasource), the server executes “ALTER SESSION SET TIME_ZONE = 'Asia/Muscat'”. (Asia/Muscat) is the timezone defined on the operating system my weblogic is installed on. If the database cannot find it from V$TIMEZONE_NAMES table, you will have that error…
    Try to change the Timezone of your weblogic server.
    Hope this will help.


  • 758802
    758802 Member Posts: 24
    edited Mar 9, 2010 3:22AM
    Thank you Zakir, it works fine.

    Edited by: AM84 on Mar 9, 2010 12:22 AM
  • 728428
    728428 Member Posts: 19
    How to change the timezone region of your weblogic server

    Go to the bin directory in your domain directory

    Edit setDomainEnv.cmd

    scroll untill you find


    Add -Duser.timezone=EET

    you can replace the EET timezone with your own one

    Best Regards ,
    A. Safwat
  • 24178
    24178 Member Posts: 2
    Thank you, mush dbrosius. I set time zone -Duser.timezone="+06:00". now working

    if my pc time zone +08.00 . how to solve this problem.
  • odrewien
    odrewien Member Posts: 13

    I got the same problem with WebLogic Server 10.3.3 and an ADF Application.

    First we try to set -Duser.timezone=CET in setDomainEnv.bat but ...we are facing a new problem: vary bad performance

    Then we found what happend.
    1) on Windows you MUST change to timezone (control panel | time&date) to something. And the change it to your timezone.
    2) removed the -Duser.timezone from setDomainEnv.bat
    3) Restart all Server in the domain.

    Well done - all problems disappears.
This discussion has been closed.