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

Possibility for Debezium Oracle Connector to accept NLS Time Format (For Date and Timestamp Columns)

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 3.0.2.Final
    • None
    • oracle-connector
    • None

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Feature request or enhancement

      For feature requests or enhancements, provide this information, please:

      Which use case/requirement will be addressed by the proposed feature?

      In some case there is a requirement, when we need milliseconds precision for the datetime columns, which we receive for CDC processes from Oracle Databases.

      To have such a possibility, config for a connector should have a parameter, which accepts such settings as NLS_TIMESTAMP_FORMAT, NLS_DATE_FORMAT, NLS_TIMESTAMP_TZ_FORMAT in a Oracle connection session, and then connector will convert datetime columns for a required format.

      Implementation ideas (optional)

      Changes in parser of data output from Oracle (maybe, with help of regular expressions)

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

                Created:
                Updated:
                Resolved: