Monday, 10 May 2010

Timezone Error: ORA-01882: timezone region not found

If you get this error on Jdeveloper 11g when running an application module or running a page you must set the timezone on the project properties as java options.

Go to model project properties to run/debug/profile :














Press edit and in java options type: -Duser.timezone="-03:00" and type your timezone:














Press ok, and do the same to viewcontroller project.

If the error appears on an standalone weblogic, if your weblogic is in windows, stop weblogic server, then go to:
c:\user_projects\domains\bin\setDomainEnv.cmd find:
set EXTRA_JAVA_PROPERTIES and add before %WLS_JDBC_REMOTE_ENABLED%

-Duser.timezone="-03:00"

It must be like this:
set EXTRA_JAVA_PROPERTIES ……. -Duser.timezone="-03:00" %WLS_JDBC_REMOTE_ENABLED% EXTRA_JAVA_PROPERTIES%

Start weblogic server. 

Now i have another weblogic server on suse 10, and this timezone -03:00 do not work, instead i modified the setDomainEnv.sh like this: -Duser.timezone=GMT 

1 comment:

  1. Anonymous08:36:00

    Tnks alot! You are a sweetheart, worked perfectly for me.

    ReplyDelete