Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5057

Add FAQ about ORA-01882 and Oracle 11 to documentation

XMLWordPrintable

      When using Oracle 11.2.0.4 with ojdbc8.jar, the connector may fail with an error that the database version could not be resolved due to an underlying error:

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

      We should add a FAQ entry to the documentation to note that when this happens, the user must configure the connector with the following option:

      database.oracle.jdbc.timezoneAsRegion=false
      

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: