Tuesday, June 16, 2009

Error running project in JDeveloper - "java.sql.SQLDataException: ORA-01882: timezone region not found"

I always encountered this error when I started learning Oracle ADF in JDeveloper and had found no straightforward answer in the forums. Now that I was able to find the solution through a similar case in Metalink, I thougth that it would help other beginners like me, if I will post the solution here. Error: java.sql.SQLDataException: ORA-01882: timezone region not found Error: java.lang.NumberFormatException: For input string: "" Solution: add a java option "-Duser.timezone=GMT" without the quotes in the run configuration under project properties on every project in JDeveloper. It is also important to restart the Server after configuring such java option. Tags: JDeveloper 11g R1 WebLogic
Posted by Rommel Pino at 3:52 PM

3 comments:

  1. AnonymousJanuary 19, 2010 at 6:09 AM

    great, great, great man!!!!

    ReplyDelete
  2. Sriram SMay 22, 2011 at 5:47 PM

    Thank you so much, I spent last 3 hrs searching yours helped without any confusion

    ReplyDelete
  3. VinithaDecember 28, 2012 at 10:37 AM

    thanks for the post. But if the application has more than 10 projects , then it is undesirable to set the same. Is it there any other common way to fix the issue .

    ReplyDelete

Subscribe to: Post Comments (Atom)