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

Oracle connector fails when using database.tablename.case.insensitive=true

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.5.0.Beta2
    • None
    • oracle-connector
    • None

    Description

      The option database.tablename.case.insensitive was added in DBZ-954 so that Oracle 11g would work with the connector. Both the configuration class and documentation state that this setting should only be set to true when using Oracle 11g; however, we've had several reports where users have set this on Oracle 12+ environments and experienced varied inconsistent behavior.

      See https://gitter.im/debezium/user?at=6034b854e634904e60ba19a4

      In the above discussion, an Oracle 12 user had set this option to true which caused a query that checks for a table's supplemental logging to fail because the generated SQL was:

      WHERE owner = 'SCOTT' and table_name = 'mtl_material_transactions'

      rather than

      WHERE owner = 'SCOTT' and table_name = 'MTL_MATERIAL_TRANSACTIONS'

      Due to how Oracle 12+ would match the text string, the inconsistent case in the value led to no results being returned & an error being shown to the user despite the fact they had accurately configured the supplemental logging for the table.

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-2203 Database name should not be converted to lower case if tablenameCaseInsensitive=True in Oracle Connector

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Bug - A problem that impairs or prevents the functions of the product. DBZ-2946 LogMiner could not receive changed data

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3122 Trying Debezium for Oracle but not logging any event

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed

          Task - Represents a small unit of work that is not end-user facing. DBZ-3240 Remove deprecated Oracle connector option "database.tablename.case.insensitive"

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: