search

getdozer / dozer

Dozer is a real-time data movement tool that leverages CDC from various sources and moves data into various sinks.
https://getdozer.io
GNU Affero General Public License v3.0
1.47k stars 117 forks source link

Oracle sink cannot be resumed when date columns are used #2481

Open karolisg opened 3 months ago

karolisg commented 3 months ago

Describe the bug

Cannot resume oracle sink because for second run dozer throws incompatible type error

dozer-config.yaml part

app_name: aerospike-oracle
version: 1
connections:

  - config: !Aerospike
      hosts: localhost:3000
      namespace: test
      sets:
        - transactions_denorm
      schemas: !Inline |
        {
          "transactions_denorm": {
            "schema": {
              "primary_index": [0, 1],
              "fields": [
                {
                  "name": "IDN",
                  "typ": "String",
                  "nullable": false
                },
                {
                  "name": "MOBILENO",
                  "typ": "String",
                  "nullable": false
                },
                {
                  "name": "TRAN_ID",
                  "typ": "String",
                  "nullable": false
                },
                {
                  "name": "TRAN_DATE",
                  "typ": "Date",
                  "nullable": false
                },