[Fix]-ORA-01882 timezone region not found
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: