I’m wondering whether someone can explain why the only datatype that is supported for the timestamp column is DATETIME2? I was hoping that the SQL Server JDBC Connector would support ROWVERSION as the timestamp column since this can be managed directly from the database rather than having logic update a separate column when changes are made.
Is it because the Connector only keeps a single value for all tables configured within in Connector properties? If so, is it possible to keep a separate offset value for each table?
Cheers,
Kyley