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

JDBC Kafka connect with MS SQL TimeStamp Mode

Open jnSWPC opened this issue 3 years ago • 1 comments

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

jnSWPC avatar May 10 '21 17:05 jnSWPC

I have the same issue @jnSWPC did you manage to fix it?

mohannadkayali avatar Apr 05 '22 06:04 mohannadkayali