For a query paginated on AS400 via the getResultList method in org.hibernate.query.Query, I see the right paging values in limit object in the org.hibernate.sql.ast.spi.AbstractSqlAstTranslator but the method needsMawRows() called in the method getMaxRows() returns hardly false.

So paging values are not used to build the query and pagination does not work properly.

Workaround found: I override the AbstractSqlAstTranslator to return true in getMaxRows() method.