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

Add FAQ about ORA-01882 and Oracle 11 to documentation

    XMLWordPrintable

Details

    Description

      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
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: