stmt = connection.createStatement();

stmt.setFetchSize(Integer.MIN_VALUE);            

stmt.executeUpdate("DROP TEMPORARY TABLE IF EXISTS tmp.a");               

stmt.executeUpdate("CREATE TEMPORARY TABLE tmp.a ( a INT )");

stmt.executeUpdate("INSERT INTO tmp.a VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)");

//optimize internally returns a ResultSet that I do not read

stmt.executeUpdate("OPTIMIZE TABLE tmp.a");

final ResultSet rs = stmt.executeQuery("SELECT a from tmp.a");                

int count = 0;

//this resultset iteration is not streamed,it is fully loaded on memory

while (rs.next()) {

    count++;

}

System.out.println(count + " rows read");

rs.close();          

 public void loadFully(boolean skip, Protocol protocol) throws SQLException {

        if (fetchSize != 0) {           

            //fetchSize = 0; comenting this to avoid reading 0 in the next statement

            if (resultSet != null) {

          ....