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

Database name should not be converted to lower case if tablenameCaseInsensitive=True in Oracle Connector

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.6.0.Beta1
    • 1.1.2.Final
    • oracle-connector
    • None

    Description

      If `database.tablename.case.insensitive` is set to true in configuration, the source database name is also converted to lower case in method `getTableId`:

      https://github.com/debezium/debezium-incubator/blob/5771795222b1bb7cae73059d8f78a8499d20a4d0/debezium-connector-oracle/src/main/java/io/debezium/connector/oracle/LcrEventHandler.java#L125

      This will lead to an exception "No metadata registered for captured table" when processing streaming LCR, because the source database name stored in registered schema is NOT converted. 

      Attachments

        Issue Links

          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3190 Oracle connector fails when using database.tablename.case.insensitive=true

          • 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

          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
              renqingsheng Qingsheng Ren (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: