[jira] [Created] (ARROW-16035) [Java] Arrow to JDBC ArrowVectorIterator with does not terminate with empty result set

["Jonathan Swenson (Jira)" <ji...@apache.org>]

Jonathan Swenson created ARROW-16035:
----------------------------------------

             Summary: [Java] Arrow to JDBC ArrowVectorIterator with does not terminate with empty result set
                 Key: ARROW-16035
                 URL: https://issues.apache.org/jira/browse/ARROW-16035
             Project: Apache Arrow
          Issue Type: Bug
          Components: Java
    Affects Versions: 7.0.0
            Reporter: Jonathan Swenson


Using an ArrowVectorIterator built from a JDBC Result Set that is empty causes the iterator to never terminate. 
{code:java}
ArrowVectorIterator iterator =
    JdbcToArrow.sqlToArrowVectorIterator(conn.createStatement()
        .executeQuery("select 1 from table1 where false"), config); {code}
 

It appears as though this is due to the implementation of the [hasNext()|https://github.com/apache/arrow/blob/master/java/adapter/jdbc/src/main/java/org/apache/arrow/adapter/jdbc/ArrowVectorIterator.java#L158] method.

The expectation is that the `isAfterLast()` method on a JDBC result set return true when the result set is empty. However, according to the [JDBC documentation|https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSet.html#isAfterLast()] it will always return false when the result set is empty. 
{quote}Returns:{{{}true{}}} if the cursor is after the last row; {{false}} if the cursor is at any other position or the result set contains no rows
{quote}
 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)