kafka-connect-oracle icon indicating copy to clipboard operation
kafka-connect-oracle copied to clipboard

Tombstone Records

Open stariq2 opened this issue 5 years ago • 3 comments

It's a great connector but I couldn't get deletion work as a tombstone record. Any recommendations?

stariq2 avatar Jul 27 '19 08:07 stariq2

It's a great connector but I couldn't get deletion work as a tombstone record. Any recommendations?

have you solve problem?

ghost avatar Mar 19 '20 10:03 ghost

Hi, This connector can capture deletion of records and this Kafka messages can be used to populate on target system. Could you please give some detail information what you expect ? Thanks

erdemcer avatar Mar 30 '20 06:03 erdemcer

just like debezium.

when delete event is emitted by database debezium emit two messages: a delete message and a tombstone message that as a signal to kafka compaction process.

i have made a simple modify when operation equal 'delete' records will extra add tombstone message in oraclesourcetask class.

records.add( new SourceRecord(sourcePartition(), sourceOffset(scn, commitScn, rowId), topic,keySchema,Key, null, null));

ghost avatar Apr 09 '20 02:04 ghost