[NIFI-3585] DB Adapter for MS SQL 2008

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Core Framework
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 10/Mar/17 17:32
• Updated: 28/Mar/17 13:33
• Resolved: 28/Mar/17 13:33

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.

Issue Links

• is a clone of: NIFI-3481 DB Adapter for MS SQL 2012+
• links to: GitHub Pull Request #1584