[NIFI-4561] ExecuteSQL Stopped Returning FlowFile for non-ResultSet Queries

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Assignee: Peter Wicks
• Reporter: Peter Wicks
• Created: 01/Nov/17 01:23
• Updated: 24/Apr/18 15:01
• Resolved: 24/Apr/18 15:01

Description

While most people use ExecuteSQL for Select statements, some JDBC drivers allow you to execute any kind of statement, including multi-statement requests.

This allowed users to submit multiple SQL statements in one JDBC Statement and get back multiple result sets. This was part of the reason I wrote NIFI-3432.

After having NIFI-3432 merged, I found that some request types no longer cause a FlowFile to be generated because there is no ResultSet. Also, if request types are mixed, such as an insert followed by a Select, then no ResultSet is returned because the first result is not a result set but an Update Count.

Issue Links

• links to: GitHub Pull Request #2243