| 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; } |