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

Oracle: Add support for different representations of "NUMBER" Data Type

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 1.1.0.Alpha1
    • 0.10.0.Beta4
    • oracle-connector
    • None

    Description

      I've been able to configure Oracle 11g and Debezium successfully.
      My Database schema has many tables with columns defined as "NUMBER", without specifying precision or scale, eg:

      CREATE TABLE SERVICES
 ( SERVICE_ID   NUMBER  NOT NULL );

      When I get this streamed into the Kafka topic, the scale is defined as 0 (zero) but there is no value.

      {
  "before": null,
  "after": {
    "Value": {
      "SERVICE_ID": {
        "scale": 0,
        "value": "\u0002\u001CO0"
      },
      ...
    }
  },
  "source": {
    "version": "0.10.0.Final",
    "connector": "oracle",
    "name": "netstream",
    "ts_ms": 1571045084752,
    "snapshot": {
      "string": "true"
    },
    "db": "db1",
    "schema": "SERVICE_OWNER",
    "table": "SERVICES",
    "txId": null,
    "scn": {
      "long": 776975
    },
    "lcr_position": null
  },
  "op": "r",
  "ts_ms": {
    "long": 1571045084758
  },
  "messagetopic": {
    "string": "netstream.SERVICE_OWNER.SERVICES"
  },
  "messagesource": {
    "string": "Debezium CDC from Oracle on netstream"
  }
}

      I'd like to see the data!

      NB: The value held in the database for SERVICE_ID is: 35409711

      Attachments

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue DBZ-807 Implement decimal.handling.mode option

          • 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-1728 io.debezium.data.VariableScaleDecimal (STRUCT) type doesn't have a mapping to the SQL database column type

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

              jpechane Jiri Pechanec
              muirandy Andy Muir (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: