Altoria Pendragon
07/18/2024, 10:26 AMtEnv.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?