| change 1:
@Override
public String processSql(String sql, RowSelection selection) {
// if (LimitHelper.hasFirstRow( selection )) { // throw new UnsupportedOperationException( "query result offset is not supported" ); // } return sql + " fetch first " + getMaxOrLimit( selection ) + " rows only";
} change 2;
// DB2390 Dialect is missing this override!
@Override
public boolean supportsLimitOffset() { return false; } change 3:
@Override
public String getLimitString(String sql, int offset, int limit) {
// if ( offset > 0 ) { // throw new UnsupportedOperationException( "query result offset is not supported" ); // } if ( limit == 0 ) { return sql; } return sql + " fetch first " + limit + " rows only ";
} @Override
public LimitHandler getLimitHandler() { return LIMIT_HANDLER; } |
