public class ScrollableResultIterator<T> implements Iterator<T> {
    private final ScrollableResults results;
    private Boolean hasNext;

    public ScrollableResultIterator(ScrollableResults results) {
        this.results = results;
    }

    @Override
    public boolean hasNext() {
        if (hasNext == null) {
            hasNext = results.next();
        }
        return hasNext;
    }

    @Override
    public T next() {
        if (hasNext()) {
            hasNext = null;
            return (T) results.get(0);

        } else {
            throw new NoSuchElementException();
        }
    }

    @Override
    public void remove() {
        throw new UnsupportedOperationException();
    }
}

Iterator<Keyword> scrollableResultIterator = getDao().findByDateBeforeOrIsNull(maxDate);

while ( scrollableResultIterator.hasNext() ) {
    scrollableResultIterator.next();            
}

org.hibernate.exception.GenericJDBCException: could not advance using next()