[jira] [Created] (NIFI-8376) Gracefully handle SQL exceptions in ResultSetRecordSet

["Matt Burgess (Jira)" <ji...@apache.org>]

Matt Burgess created NIFI-8376:
----------------------------------

             Summary: Gracefully handle SQL exceptions in ResultSetRecordSet
                 Key: NIFI-8376
                 URL: https://issues.apache.org/jira/browse/NIFI-8376
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Extensions
            Reporter: Matt Burgess


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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)