[Fix]-ORA-01882 timezone region not found

Wikitechy | 3034 Views | oracle | 28 May 2016

 

ORA-01882: timezone region not found

Scenario:

Access an Oracle Database Table from Java Application.

Error:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found.

Reason for the error:

The error occurs due to invalid time zone settings used in editors such as eclipse or netbeans or when using an invalid JDBC driver.

Fix 1:

  • Check the versions for Oracle JDBC driver and Oracle database. 
  • Ojdbc6.jar version 11.1.0.7.0 works well with Oracle 9.2.0.4.0 server than ojdbc6.jar (version 11.2.0.3.0). 

Fix 2:

Apply the following settings in Netbeans:
  • Right-click on the project ->select properties -> choose Run under categories: 
under VM Options enter:
  • Duser.timezone=UTC or -Duser.timezone=GMT.
  • Click Ok, then re-run your program.

Fix 3:

Apply the following settings in eclipse:
  • Go to run -> configuration. Under JRE tab in VM Arguments section use the below settings:



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise