nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charlie Meyer <charlie.me...@civitaslearning.com>
Subject ExecuteSqlRecord, using SQL Server rowversion as max value column
Date Wed, 21 Nov 2018 05:00:33 GMT
Hi,

I'm attempting to do incremental fetch from a Microsoft SQL Server database
and would like to use rowversion [1] as my maximum value column. When I
configured the processor to use that column, it threw an exception [2]. Are
there known issues with using the rowversion for this purpose or
workarounds?

Thanks!

Charlie

[1]
https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-2017

[2]
https://github.com/apache/nifi/blob/d8d220ccb86d1797f56f34649d70a1acff278eb5/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/AbstractDatabaseFetchProcessor.java#L456

Mime
View raw message