[Fix]-ORA-01882 timezone region not found

Wikitechy | 3034 Views | oracle | 28 May 2016


ORA-01882: timezone region not found


Access an Oracle Database Table from Java Application.


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 works well with Oracle server than ojdbc6.jar (version 

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:


Bug Bounty
IOT Hackathon

Join our Community