Criteria criteria = session.createCriteria(CertRequest.class);
        List<CertRequest> certRequests = (List<CertRequest>)criteria
          .setFirstResult(0)
          .setMaxResults(BATCH_SIZE)
          .addOrder(Order.asc("modifyTime"))
          .list();

        // Method copied from TopLimitHandler
        @Override
        public String processSql(String sql, RowSelection selection) {
            if (LimitHelper.hasFirstRow( selection )) {
                throw new UnsupportedOperationException( "query result offset is not supported" );
            }

            final int selectIndex = sql.toLowerCase(Locale.ROOT).indexOf( "select" );
            final int selectDistinctIndex = sql.toLowerCase(Locale.ROOT).indexOf( "select distinct" );
            final int insertionPoint = selectIndex + (selectDistinctIndex == selectIndex ? 15 : 6);
            Integer maxRows = selection.getMaxRows();
            return new StringBuilder( sql.length() + 8 )
                    .append( sql )
//                    .insert( insertionPoint, " TOP ? " )
                    .insert( insertionPoint, " TOP " + maxRows.toString() + " ")
                    .toString();
        }

        // Method copied from AbstractLimitHandler
        @Override
        public int bindLimitParametersAtStartOfQuery(RowSelection selection, PreparedStatement statement, int index)
                throws SQLException {
            return bindLimitParametersFirst() ? bindXxxLimitParameters( selection, statement, index ) : 0;
        }

        // Method copied from AbstractLimitHandler
        @Override
        public int bindLimitParametersAtEndOfQuery(RowSelection selection, PreparedStatement statement, int index)
                throws SQLException {
            return !bindLimitParametersFirst() ? bindXxxLimitParameters( selection, statement, index ) : 0;
        }
        /**
         * Default implementation of binding parameter values needed by the LIMIT clause.
         *
         * @param selection the selection criteria for rows.
         * @param statement Statement to which to bind limit parameter values.
         * @param index Index from which to start binding.
         * @return The number of parameter values bound.
         * @throws SQLException Indicates problems binding parameter values.
         */
        protected final int bindXxxLimitParameters(RowSelection selection, PreparedStatement statement, int index)
                throws SQLException {
            if ( !supportsVariableLimit() || !LimitHelper.hasMaxRows( selection ) ) {
                return 0;
            }
            final int firstRow = convertToFirstRowValue( LimitHelper.getFirstRow( selection ) );
//            final int lastRow = getMaxOrLimit( selection );
            final boolean hasFirstRow = supportsLimitOffset() && ( firstRow > 0 || forceLimitUsage() );
            final boolean reverse = bindLimitParametersInReverseOrder();
            if ( hasFirstRow ) {
                statement.setInt( index + ( reverse ? 1 : 0 ), firstRow );
            }
//            statement.setInt( index + ( reverse || !hasFirstRow ? 0 : 1 ), lastRow );
            return hasFirstRow ? 2 : 1;
        }