-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
None
-
False
In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.
Bug report
For bug reports, provide this information, please:
What Debezium connector do you use and what version?
Oracle, 2.3.4.Final
What is the connector configuration?
connector.class = io.debezium.connector.oracle.OracleConnector
include.schema.changes = false
schema.history.internal.store.only.captured.tables.ddl = true
tombstones.on.delete = false
topic.prefix = NORTHWIND
offset.storage.file.filename =
lob.enabled = true
errors.retry.delay.initial.ms = 300
value.converter = org.apache.kafka.connect.json.JsonConverter
key.converter = org.apache.kafka.connect.json.JsonConverter
database.user = NORTHWIND
database.dbname = NORTHWIND
offset.storage = org.apache.kafka.connect.storage.MemoryOffsetBackingStore
time.precision.mode = connect
database.url = jdbc:oracle:thin:@localhost/NORTHWIND
offset.flush.timeout.ms = 5000
errors.retry.delay.max.ms = 10000
event.processing.failure.handling.mode = fail
offset.flush.interval.ms = 60000
schema.history.internal = io.debezium.relational.history.MemorySchemaHistory
errors.max.retries = -2
database.password = ********
name = engine-f274c13448d84c5580f1293d943db137
table.include.list = ^NORTHWIND.JSONTABLE$
snapshot.mode = initial_only
What is the captured database version and mode of depoyment?
Oracle 21 on Docker, https://hub.docker.com/r/gvenzl/oracle-xe
What behaviour do you expect?
JSON type column to be captured, similar to Postgres.
https://docs.oracle.com/en/database/oracle/oracle-database/21/adjsn/json-in-oracle-database.html#GUID-F6282E67-CBDF-442E-946F-5F781BC14F33
What behaviour do you see?
2023-09-25 09:27:53,330 WARN io.debezium.relational.TableSchemaBuilder [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] No converter found for column NORTHWIND.NORTHWIND.JSONTABLE.JSONFIELD of type JSON. The column will not be part of change events for that table.
Do you see the same behaviour using the latest relesead Debezium version?
Yes.
Do you have the connector logs, ideally from start till finish?
(You might be asked later to provide DEBUG/TRACE level log)
2023-09-21 17:06:54,076 INFO io.debezium.relational.RelationalSnapshotChangeEventSource [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Snapshot step 5 - Reading structure of captured tables
2023-09-21 17:06:54,076 INFO io.debezium.connector.oracle.OracleSnapshotChangeEventSource [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Only captured tables schema should be captured, capturing: [NORTHWIND.NORTHWIND.JSONTABLE]
2023-09-21 17:06:56,968 INFO io.debezium.relational.RelationalSnapshotChangeEventSource [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Snapshot step 5.a - Creating connection pool
2023-09-21 17:06:56,969 INFO io.debezium.relational.RelationalSnapshotChangeEventSource [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Created connection pool with 1 threads
2023-09-21 17:06:56,969 INFO io.debezium.relational.RelationalSnapshotChangeEventSource [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Snapshot step 6 - Persisting schema history
2023-09-21 17:06:56,969 INFO io.debezium.relational.RelationalSnapshotChangeEventSource [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Capturing structure of table NORTHWIND.NORTHWIND.JSONTABLE
2023-09-21 17:07:11,587 WARN io.debezium.relational.TableSchemaBuilder [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] Unexpected JDBC type '1111' for column 'JSONFIELD' that will be ignored
2023-09-25 09:27:53,330 WARN io.debezium.relational.TableSchemaBuilder [debezium-oracleconnector-NORTHWIND-change-event-source-coordinator] No converter found for column NORTHWIND.NORTHWIND.JSONTABLE.JSONFIELD of type JSON. The column will not be part of change events for that table.