MS JDBC DateTimeOffset support?

asked 2018-04-15 04:33:37 -0500

chris gravatar image

I'm trying to use the MS JDBC driver and the SQL Server Change Tracking Client to track changes to a MS SQL Server database and maintain Elasticsearch indexes. I've done this successfully with the JDBC Query Consumer by casting the DateTimeOffset fields to JDBC standard data types in the query. The SQL Server Change Tracking Client would be a better solution but StreamSets doesn't support DateTimeOffset data type.

There is a Jira ticket (SDC-4747) opened in 2016 and untouched. That tickets states that the jTDS driver can be used to work around this issue but jTDS hasn't been updated since 2013 and I don't believe it works with Java 8 now required for StreamSets.

The error returned is: com.streamsets.pipeline.api.StageException: JDBC_37 - Unsupported type -155 for column ModifiedDtTm. (a DateTimeOffset data type)

Any suggestions?

Thanks

edit retag flag offensive close merge delete