public Db2PagingQueryProviderTests() { pagingQueryProvider = new Db2PagingQueryProvider(); }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateLimitGroupedSqlQuery(this, true, buildLimitClause(pageSize)); } else { return SqlPagingQueryUtils.generateLimitSqlQuery(this, true, buildLimitClause(pageSize)); } }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateLimitSqlQuery(this, false, buildLimitClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateLimitSqlQuery(this, false, buildLimitClause(pageSize)); }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateLimitGroupedSqlQuery(this, true, buildLimitClause(pageSize)); } else { return SqlPagingQueryUtils.generateLimitSqlQuery(this, true, buildLimitClause(pageSize)); } }
case DB2VSE: case DB2ZOS: case DB2AS400: provider = new Db2PagingQueryProvider(); break; case H2: provider = new H2PagingQueryProvider(); break; case HSQL: provider = new HsqlPagingQueryProvider(); break;
case DB2VSE: case DB2ZOS: case DB2AS400: provider = new Db2PagingQueryProvider(); break; case H2: provider = new H2PagingQueryProvider(); break; case HSQL: provider = new HsqlPagingQueryProvider(); break;