@Override public int getFetchLimit() { return mdDelegate.getFetchLimit(); }
public int getFetchLimit() { return metadata.getFetchLimit(); }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int limit = queryMetadata.getFetchLimit(); if (limit > 0) { buffer.append(" RETURN RESULTS ").append(limit); } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int limit = queryMetadata.getFetchLimit(); if (limit > 0 && buffer.length() > SELECT_PREFIX.length()) { if (SELECT_PREFIX.equals(buffer.substring(0, SELECT_PREFIX.length()))) { buffer.insert(SELECT_PREFIX.length(), " TOP " + limit); } } } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { // limit results int offset = queryMetadata.getFetchOffset(); int limit = queryMetadata.getFetchLimit(); if (offset > 0) { buffer.append(" OFFSET ").append(offset); } if (limit > 0) { buffer.append(" FETCH NEXT ").append(limit).append(" ROWS ONLY "); } } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int offset = queryMetadata.getFetchOffset(); int limit = queryMetadata.getFetchLimit(); if (limit > 0 || offset > 0) { int max = (limit <= 0) ? Integer.MAX_VALUE : limit + offset; buffer.insert(0, "select * from ( select tid.*, ROWNUM rnum from ("); buffer.append(") tid where ROWNUM <=").append(max).append(") where rnum > ").append(offset); } }
public int getFetchLimit() { if (!overrideExists(QueryMetadata.FETCH_LIMIT_PROPERTY)) { return info.getFetchLimit(); } Number n = (Number) overrides.get(QueryMetadata.FETCH_LIMIT_PROPERTY); return n != null ? n.intValue() : 0; }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { // limit results int offset = queryMetadata.getFetchOffset(); int limit = queryMetadata.getFetchLimit(); if (limit > 0) { buffer.append(" LIMIT ").append(limit); } if (offset > 0) { buffer.append(" OFFSET ").append(offset); } } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int limit = queryMetadata.getFetchLimit(); int offset = queryMetadata.getFetchOffset(); if (limit > 0) { String sql = buffer.toString(); // If contains distinct insert top limit after if (sql.startsWith("SELECT DISTINCT ")) { buffer.replace(0, 15, "SELECT DISTINCT TOP " + (offset + limit)); } else { buffer.replace(0, 6, "SELECT TOP " + (offset + limit)); } } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int offset = queryMetadata.getFetchOffset(); int limit = queryMetadata.getFetchLimit(); if (offset > 0 || limit > 0) { buffer.append(" LIMIT "); // both OFFSET and LIMIT must be present, so come up with defaults // if one of // them is not set by the user if (limit == 0) { limit = Integer.MAX_VALUE; } buffer.append(limit).append(" OFFSET ").append(offset); } } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int limit = queryMetadata.getFetchLimit(); int offset = queryMetadata.getFetchOffset(); if (limit > 0) { String sql = buffer.toString(); // If contains distinct insert top limit after if (sql.startsWith("SELECT DISTINCT ")) { buffer.replace(0, 15, "SELECT DISTINCT TOP " + (offset + limit)); } else { buffer.replace(0, 6, "SELECT TOP " + (offset + limit)); } } } }
@Override protected void appendLimitAndOffsetClauses(StringBuilder buffer) { int offset = queryMetadata.getFetchOffset(); int limit = queryMetadata.getFetchLimit(); if (offset > 0 || limit > 0) { buffer.append(" LIMIT "); // both OFFSET and LIMIT must be present, so come up with defaults // if one of // them is not set by the user if (limit == 0) { limit = Integer.MAX_VALUE; } buffer.append(limit).append(" OFFSET ").append(offset); } } }
public String createSqlString() throws Exception { String sqlString = super.createSqlString(); QueryMetadata info = getQuery().getMetaData(getEntityResolver()); if (info.getFetchLimit() > 0) { sqlString = "SELECT * FROM (" + sqlString + ") WHERE rownum <= " + info.getFetchLimit(); } return sqlString; }
public String createSqlString() throws Exception { String sql = super.createSqlString(); // limit results int limit = getQuery().getMetaData(getEntityResolver()).getFetchLimit(); if (limit > 0 && sql.startsWith(SELECT_PREFIX)) { return SELECT_PREFIX + " TOP " + limit + sql.substring(SELECT_PREFIX.length()); } return sql; } }
public String createSqlString() throws Exception { String sql = super.createSqlString(); // limit results int limit = getQuery().getMetaData(getEntityResolver()).getFetchLimit(); if (limit > 0 && sql.startsWith(SELECT_PREFIX)) { return SELECT_PREFIX + " TOP " + limit + sql.substring(SELECT_PREFIX.length()); } return sql; } }
/** * Warn user in case query uses both limit and joint prefetch, as we don't support this combination. */ private void checkLimitAndJointPrefetch() { if(queryMetadata.getFetchLimit() == 0 && queryMetadata.getFetchOffset() == 0) { return; } if(!jointPrefetchChecker.haveJointNode(queryMetadata.getPrefetchTree())) { return; } logger.warn("Query uses both limit and joint prefetch, this most probably will lead to incorrect result. " + "Either use disjointById prefetch or get full result set."); }
public String createSqlString() throws Exception { String sql = super.createSqlString(); // limit results int limit = getQuery().getMetaData(getEntityResolver()).getFetchLimit(); if (limit > 0) { return sql + " LIMIT " + limit; } return sql; } }
public String createSqlString() throws Exception { String sql = super.createSqlString(); // limit results int limit = getQuery().getMetaData(getEntityResolver()).getFetchLimit(); if (limit > 0) { return sql + " LIMIT " + limit; } return sql; } }
public String createSqlString() throws Exception { String sql = super.createSqlString(); // limit results int limit = getQuery().getMetaData(getEntityResolver()).getFetchLimit(); if (limit > 0) { return sql + " RETURN RESULTS " + limit; } return sql; } }
/** * Copies values of another QueryMetadata object to this object. */ void copyFromInfo(QueryMetadata info) { this.lastEntityResolver = null; this.lastRoot = null; this.classDescriptor = null; this.dbEntity = null; this.dataMap = null; this.fetchingDataRows = info.isFetchingDataRows(); this.fetchLimit = info.getFetchLimit(); this.pageSize = info.getPageSize(); this.cacheStrategy = info.getCacheStrategy(); this.cacheKey = info.getCacheKey(); this.cacheGroup = info.getCacheGroup(); this.resultSetMapping = info.getResultSetMapping(); setPrefetchTree(info.getPrefetchTree()); }