[NIFI-8376] Gracefully handle SQL exceptions in ResultSetRecordSet

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Extensions
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 29/Mar/21 16:47
• Updated: 08/Sep/21 13:12
• Resolved: 08/Sep/21 13:12

Description

There is code in ResultSetRecordSet to call the JDBC API method isAfterLast() when attempting to determine the element type for an array. It is called to avoid possible exceptions later when getArray() is called.

However because isAfterLast() is a JDBC API method, it too may be unsupported by drivers (and at the time of this writing, it is unsupported by the Presto JDBC driver). This defeats the purpose of the defensive code and can cause its own issues.

This code should be refactored to more gracefully handle "not supported" exceptions.

Issue Links

• links to: GitHub Pull Request #4951