@Override public void setQueryStatementProperties(Statement stmt, Query query) throws SQLException { int limit = query.getLimit(); if (limit >= 0) { stmt.setFetchSize(limit); stmt.setMaxRows(limit); } }
@Override public void setQueryStatementProperties(Statement stmt, Query query) throws SQLException { int limit = query.getLimit(); if (limit >= 0) { stmt.setFetchSize(limit); stmt.setMaxRows(limit); } }
@Override protected String renderQueryLimit(final Query query) { final StringBuilder sql = new StringBuilder(); // H2 requires a LIMIT when OFFSET is specified; -1 indicates unlimited if (query.getLimit() < 0 && query.getOffset() > 0) { sql.append(" LIMIT -1"); } sql.append(super.renderQueryLimit(query)); return sql.toString(); }
@Override protected String renderQueryLimit(final Query query) { StringBuilder sql = new StringBuilder(); // use the "LIMIT [<OFFSET>, ] <LIMIT>" style, with (2^64-1) meaning "unlimited" int offset = query.getOffset(); int limit = query.getLimit(); if (offset > 0) { sql.append(" LIMIT "); sql.append(offset); sql.append(", "); if (limit >= 0) { sql.append(limit); } else { sql.append("18446744073709551615"); } } else if (limit >= 0) { sql.append(" LIMIT "); sql.append(limit); } return sql.toString(); }
@Override protected String renderQueryLimit(final Query query) { final StringBuilder sql = new StringBuilder(); // H2 requires a LIMIT when OFFSET is specified; -1 indicates unlimited if (query.getLimit() < 0 && query.getOffset() > 0) { sql.append(" LIMIT -1"); } sql.append(super.renderQueryLimit(query)); return sql.toString(); }
@Override protected String renderQueryLimit(final Query query) { StringBuilder sql = new StringBuilder(); // use the "LIMIT [<OFFSET>, ] <LIMIT>" style, with (2^64-1) meaning "unlimited" int offset = query.getOffset(); int limit = query.getLimit(); if (offset > 0) { sql.append(" LIMIT "); sql.append(offset); sql.append(", "); if (limit >= 0) { sql.append(limit); } else { sql.append("18446744073709551615"); } } else if (limit >= 0) { sql.append(" LIMIT "); sql.append(limit); } return sql.toString(); }
StringBuilder sql = new StringBuilder(); int limit = query.getLimit(); if (limit >= 0) { sql.append(" LIMIT ");
@Override protected String renderQueryLimit(Query query) { StringBuilder sql = new StringBuilder(); if (Query.QueryType.SELECT.equals(query.getType())) { int offset = query.getOffset(); int limit = query.getLimit(); if (offset > 0 && limit >= 0) { sql.append(" ) QUERY_INNER WHERE ROWNUM <= "); sql.append(offset + limit); sql.append(" ) WHERE ROWNUM_INNER > "); sql.append(offset); } else if (offset > 0) { sql.append(" ) QUERY_INNER ) WHERE ROWNUM_INNER > "); sql.append(offset); } else if (limit >= 0) { sql.append(" ) WHERE ROWNUM <= "); sql.append(limit); } } return sql.toString(); }
@Override protected String renderQueryLimit(Query query) { StringBuilder sql = new StringBuilder(); if (Query.QueryType.SELECT.equals(query.getType())) { int offset = query.getOffset(); int limit = query.getLimit(); if (offset > 0 && limit >= 0) { sql.append(" ) QUERY_INNER WHERE ROWNUM <= "); sql.append(offset + limit); sql.append(" ) WHERE ROWNUM_INNER > "); sql.append(offset); } else if (offset > 0) { sql.append(" ) QUERY_INNER ) WHERE ROWNUM_INNER > "); sql.append(offset); } else if (limit >= 0) { sql.append(" ) WHERE ROWNUM <= "); sql.append(limit); } } return sql.toString(); }
StringBuilder sql = new StringBuilder(); int limit = query.getLimit(); if (limit >= 0) { sql.append(" LIMIT ");
@Override protected String renderQuerySelect(final Query query, final TableNameConverter converter, final boolean count) { StringBuilder sql = new StringBuilder(); // see http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html if (Query.QueryType.SELECT.equals(query.getType())) { int offset = query.getOffset(); int limit = query.getLimit(); if (offset > 0) { sql.append("SELECT * FROM ( SELECT QUERY_INNER.*, ROWNUM ROWNUM_INNER FROM ( "); } else if (limit >= 0) { sql.append("SELECT * FROM ( "); } } sql.append(super.renderQuerySelect(query, converter, count)); return sql.toString(); }
@Override protected String renderQuerySelect(final Query query, final TableNameConverter converter, final boolean count) { StringBuilder sql = new StringBuilder(); // see http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html if (Query.QueryType.SELECT.equals(query.getType())) { int offset = query.getOffset(); int limit = query.getLimit(); if (offset > 0) { sql.append("SELECT * FROM ( SELECT QUERY_INNER.*, ROWNUM ROWNUM_INNER FROM ( "); } else if (limit >= 0) { sql.append("SELECT * FROM ( "); } } sql.append(super.renderQuerySelect(query, converter, count)); return sql.toString(); }
int limit = query.getLimit(); int offset = query.getOffset(); if (limit >= 0 || offset > 0) {
@Override protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) { StringBuilder sql = new StringBuilder(); String tableName = query.getTable(); if (tableName == null) { tableName = converter.getName(query.getTableType()); } switch (query.getType()) { case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT "); } int limit = query.getLimit(); if (limit >= 0) { if (query.getOffset() > 0) { limit += query.getOffset(); } sql.append("TOP ").append(limit).append(' '); } if (count) { sql.append("COUNT(*)"); } else { sql.append(querySelectFields(query, converter)); } sql.append(" FROM ").append(queryTableName(query, converter)); break; } return sql.toString(); }
int limit = query.getLimit(); int offset = query.getOffset(); if (limit >= 0 || offset > 0) {
@Override protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) { StringBuilder sql = new StringBuilder(); String tableName = query.getTable(); if (tableName == null) { tableName = converter.getName(query.getTableType()); } switch (query.getType()) { case SELECT: sql.append("SELECT "); if (query.isDistinct()) { sql.append("DISTINCT "); } int limit = query.getLimit(); if (limit >= 0) { if (query.getOffset() > 0) { limit += query.getOffset(); } sql.append("TOP ").append(limit).append(' '); } if (count) { sql.append("COUNT(*)"); } else { sql.append(querySelectFields(query, converter)); } sql.append(" FROM ").append(queryTableName(query, converter)); break; } return sql.toString(); }