I followed the example from the <official document...
# troubleshooting
a
I followed the example from the official documentation and successfully implemented SQL Server CDC data synchronization. The code to insert data is:
tEnv.executeSql("INSERT INTO orders_dw SELECT * FROM orders");
. For example, the initial row count of the
orders_dw
table is 1, and the
orders
table is initially empty. When I click the button to run the code in IntelliJ IDEA, the row count of the
orders
table becomes 1. At this point, I insert another row into the
orders_dw
table, making the row count of
orders_dw
2, while the row count of the
orders
table remains 1. The log message shows
[pool-9-thread-1] INFO io.debezium.jdbc.JdbcConnection - Connection gracefully closed
. It seems that after the first synchronization, subsequent data inserts are not being captured. What should I do in this situation?