ORA-01882: timezone region not found

by

You may also try to check the version of the Oracle jdbc driver and Oracle database. Just today I had this issue when using ojdbc6.jar (version 11.2.0.3.0) to connect to an Oracle 9.2.0.4.0 server. Replacing it with ojdbc6.jar version 11.1.0.7.0 solved the issue.

I also managed to make ojdbc6.jar version 11.2.0.3.0 connect without error, by adding oracle.jdbc.timezoneAsRegion=false in file oracle/jdbc/defaultConnectionProperties.properties (inside the jar). Found this solution here (broken link)

Then, one can add -Doracle.jdbc.timezoneAsRegion=false to the command line, or AddVMOption -Doracle.jdbc.timezoneAsRegion=false in config files that use this notation.

You can also do this programmatically, e.g. with System.setProperty.

In some cases you can add the environment variable on a per-connection basis if that’s allowed (SQL Developer allows this in the “Advanced” connection properties; I verified it to work when connecting to a database that doesn’t have the problem and using a database link to a database which has).

More Related Contents:

  1. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  2. No more data to read from socket error
  3. Oracle JDBC ojdbc6 Jar as a Maven Dependency
  4. Fetch Oracle table type from stored procedure using JDBC
  5. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  6. Oracle JDBC and Oracle CHAR data type
  7. Default Schema in Oracle Connection URL
  8. URL string format for connecting to Oracle database with JDBC
  9. NLS_LANG setting for JDBC thin driver?
  10. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  11. How to change default nls_date_format for oracle jdbc client
  12. having an exception when saving oracle type object in some entity
  13. Calculate difference between 2 date / times in Oracle SQL
  14. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  15. How to generate entire DDL of an Oracle schema (scriptable)?
  16. PLSQL JDBC: How to get last row ID?
  17. Oracle Search all tables all columns for string [duplicate]
  18. Oracle PL/SQL – How to create a simple array variable?
  19. How to write / update Oracle blob in a reliable way?
  20. Setting Network Timeout for JDBC connection
  21. Number of rows affected by an UPDATE in PL/SQL
  22. Spool Command: Do not output SQL statement to file
  23. Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
  24. Get ID of last inserted record in oracle db
  25. oracle SQL plus how to end command in SQL file?
  26. Why is the GETDATE() an invalid identifier
  27. ORA-04091: table [blah] is mutating, trigger/function may not see it
  28. How to use parameters in a ‘where value in…’ clause?
  29. How to generate a version 4 (random) UUID on Oracle?
  30. Find out the history of SQL queries

Leave a Comment