kafka-connect-jdbc
kafka-connect-jdbc copied to clipboard
JDBC Kafka connect with MS SQL TimeStamp Mode
I am trying to connect to MS SQL table and detect changes based on timestamp mode. The table in MS SQL has a column of type DateTime2. When I run Kafka and make updates to the Datetime2 column in the SQL table , the change is not getting detected on kafka side and there seem to be no errors. Build Mode and Increment mode works but not timestamp. Is this connector mode supposed to work with MS SQL? If yes, can someone help identify the issue
SQL table- Table1 Id INT Name VARCHAR(50) Mdate DateTime2
The config of the connector is as follows: name=SqlConnection connector.class=io.confluent.connect.jdbc.JdbcSourceConnector tasks.max=1 connection.url=jdbc:sqlserver://<DbServer>; connection.database=<DBName> connection.user=<User> connection.password=<Password> mode=timestamp timestamp.column.name=MDate topic.prefix=test-mssql-timeIncre validate.non.null=false query=Select * From Table1 poll.interval.ms=36000
I have the same issue @jnSWPC did you manage to fix it?