Details
-
Bug
-
Status: Patch Available
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Discovered during NIFI-5049. According ResultSet.next() javadoc:
When a call to the next method returns false, the cursor is positioned after the last row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown. If the result set type is TYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will return false or throw an SQLException on a subsequent call to next.
With Phoenix Database and QueryDatabaseTable the exception java.sql.SQLException: ERROR 1101 (XCL01): ResultSet is closed is raised.