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

"io.debezium.connector.jdbc.transforms.FieldNameTransformation", "transforms.topic-lowercase.column.naming.style": "lower_case" is not work

XMLWordPrintable

    • Critical

      { "connector.class": "io.debezium.connector.jdbc.JdbcSinkConnector"
       "connection.password": "Ab123456!"
       "tasks.max": "3"
       "transforms": "unwrap,replacenullcharacter,topic-lowercase"
       "transforms.replacefield.replace.null.with.default": "false"
       "schema.evolution": "none"
       "quote.identifiers":"false"
       "transforms.unwrap.drop.tombstones": "false"
       "transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState"
       "insert.mode": "upsert"
       "table.name.format": "public.controlbranch"
       "primary.key.mode": "record_key"
       "topics": "SqlServer_1192.testDB.elois.ControlBranch"
       "batch.size": "2000"
       "consumer.max.poll.records": "2000"
       "connection.username": "postgres"
       "connection.pool.max_size": "1"
       "delete.enabled": "true"
       "transforms.replacenullcharacter.type": "com.lenovo.xdts.transforms.ReplaceMessageNULLCharacter"
       "auto.create": "false"
       "primary.key.fields": "ida2a2"
       "connection.url": "jdbc:postgresql://10.122.198.189:5432/pg_db?currentSchema=public&stringtype=unspecified"
       "connection.pool.min_size": "1"
       "transforms.topic-lowercase.type": "io.debezium.connector.jdbc.transforms.FieldNameTransformation"
       "[transforms.topic-lowercase.column.naming.style|http://transforms.topic-lowercase.column.naming.style/]": "lower_case" 
      }
      

       

       

      I wanted to convert the uppercase fields from the source database table to lowercase in the target database, and I used the above configuration, but it didn't work.

       

       

       

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

                Created:
                Updated:
                Resolved: