Workaround for MSSQL connector datetimeoffset bug

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is asking for a workaround for the known bug in the MSSQL connector related to datetimeoffset. They also inquire if anyone has forked the code to try to fix the issue by modifying the MssqlDebeziumConverter.java file.


Question

hi! quick question about MSSQL connector and this already known bug with datetimeoffset https://github.com/airbytehq/airbyte/issues/36225

  1. does anyone know of a workaround?
  2. has anyone forked to temporarily modify the https://github.com/airbytehq/airbyte/blob/8e4cecf646badf41a78df026b8d5374cfe01d97a/airbyte-integrations/connectors/source-mssql/src/main/java/io/airbyte/integrations/source/mssql/MssqlDebeziumConverter.java#L25|MssqlDebeziumConverter to try to fix the issue? I created a small snippet that shows that the expected format works as long as the datetimeoffset provided by the jbdc driver contains all 7 fractional digits: http://tpcg.io/_WNLQ8N, my guess is that the driver being used is cropping those decimals and causing the converter to fail

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mssql-connector", "datetimeoffset", "bug", "workaround", "fork", "MssqlDebeziumConverter.java"]