[
https://issues.apache.org/jira/browse/NIFI-3585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess updated NIFI-3585:
-------------------------------
Description:
NIFI-3481 introduced a DatabaseAdapter implementation for Microsoft SQL Server
2012+, it is not compatible with MS SQL 2008 because of its use of OFFSET and
FETCH, e.g.
This case is to introduce support for earlier versions of SQL Server to the
database fetching processors such as QueryDatabaseTable and GenerateTableFetch.
It may be the case that the generated SQL is awkward and less-than-ideal (more
like Oracle's pagination query), but this will enable those processors to
interact with SQL Server versions prior to 2012.
was:
Adding a new DB Adapter for MS SQL. MS SQL does paging of queries differently
then other RDBMS', including a lack of "LIMIT".
This adds functionality for TOP and OFFSET/FETCH for paging of results with the
GenerateTableFetch.
> DB Adapter for MS SQL 2008
> --------------------------
>
> Key: NIFI-3585
> URL: https://issues.apache.org/jira/browse/NIFI-3585
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Core Framework
> Affects Versions: 1.2.0
> Reporter: Matt Burgess
> Assignee: Matt Burgess
> Priority: Minor
> Fix For: 1.2.0
>
>
> NIFI-3481 introduced a DatabaseAdapter implementation for Microsoft SQL
> Server 2012+, it is not compatible with MS SQL 2008 because of its use of
> OFFSET and FETCH, e.g.
> This case is to introduce support for earlier versions of SQL Server to the
> database fetching processors such as QueryDatabaseTable and
> GenerateTableFetch. It may be the case that the generated SQL is awkward and
> less-than-ideal (more like Oracle's pagination query), but this will enable
> those processors to interact with SQL Server versions prior to 2012.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
