Forum Stats

  • 3,770,911 Users
  • 2,253,180 Discussions
  • 7,875,653 Comments

Discussions

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

676629
676629 Member Posts: 1
edited Sep 15, 2011 5:00AM in JDeveloper and ADF
Hi,
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.

ale.
Tagged:
«1

Answers

  • hofespet
    hofespet Member Posts: 597
    Hi,

    http://forums.oracle.com/forums/search.jspa?objID=f83&q=ORA-01882

    regards
    Peter
  • 549039
    549039 Member Posts: 175
    put "-Duser.timezone="+02:00" into java arguments of the project
    kquizak
  • 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!

    zakir
    ===
  • 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 11.1.1.1.0 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(SQLStateMapping.java:79)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)

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

    Regards,
    Amit
  • 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.

    Rgds

    Nicolas
  • 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

    EXTRA_JAVA_PARAMETERS

    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
    Hi,

    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.