This content has been marked as final. Show 15 replies
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
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
I am new to ADF and trying to create ADF Table from Database Table using Entity and View Objects.
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.
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.
Follow the below steps. I also was encountering the same issue and now it is resolved:
1. Open the ViewController package
2. Under this, open WEB-INF/web.xml
3. The web.xml file gets opened. Go to 'Overview' tab --> Application
4. Go to the section 'Locale Encoding Mapping'
5. Click the "+" symbol
6. For 'Locale', enter some value like 'en_US' and for encoding, enter 'Cp1252'
7. Save, stop the weblogic server instance and run the file. And Done.
- Venu Bhagavatula
Solved for me
Thanks a lot ahmedsafwat. That was great.
a- Changing Java Option of the projects -> same error
b- Changing OS timezone -> same error
c- Adding Locale and Encoding in Locale Encoding Mapping -> same error
Here are the steps that solved the problem (for me):
1- Stop (or exit) wls
2- Edit setDomainEnv.cmd
for me it's located in C:\Oracle\Middleware\user_projects\domains\"mydomain"\bin\
3- Search for line that start with "set EXTRA_JAVA_PROPERTIES="
4- At the end of the line add space and "-Duser.timezone=UTC"
UTC can be changed with another timezone
5- Start wls
These steps solved the problem in "remote wls"
Other solutions (listed above a, b, c) may solve the problem in "integrated wls"
I'm using JDeveloper 126.96.36.199.0 on Windows Server 2003
Thanks to all