Status: Closed (View Workflow)
I use debezium connector to extract data from oracle 11g/12c.
I found the topic is missing a lot of messages then i wrote a little test code. Below is the code
Basically the code is turned off the auto commit and use jdbc transaction, so what happened is "insert multiple rows , then do a single commit " i can only see ONE message is produced to the topic
Then i try to debug the code what i found the code below in oracle-connector
"LcrEventHandler.java , line 56 "
what happens in oracle multiple DML in one transaction share same scn , so when this handler processed a LCR, if next LCR have same scn it will just return.
I don't fully understand the logic , this is all information i know.
Thanks for the help