code: private ResultSet getNextResultSet() throws SQLException {
          ResultSet result = null;
  
          while (stmt.getMoreResults() == true) {
  
              // when gerMoreResults are returned - some drivers close previous ResultSets - therefore we cannot read them again.
              if (this.type == Type.UPDATE_SCROLL || this.type == Type.READ_ONLY_SCROLL) {
                  throw new MjdbcSQLException("Lazy cache scroll does not support Multiple ResultSets. Pleae use" +
                          "non-scrollable lazy handlers or cached output handlers.");
              }
  
              if (closedResultSet.contains(result) == false) {
                  result = stmt.getResultSet();
                  break;
              }
          }
  
          return result;
      }
docs: Returns next (not closed) result set. If there is no more result sets - null is returned.
  {@link Statement} is used to fetch next {@link ResultSet}
  
  @return next result set, null otherwise
  @throws SQLException