[hibernate-issues] [JIRA] (HHH-16376) Paginated results for AS400

Nicolas Chantreau ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a2a370... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjliM2YyOWMy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16376?atlOrigin=eyJpIjoiNjliM2... ) HHH-16376 ( https://hibernate.atlassian.net/browse/HHH-16376?atlOrigin=eyJpIjoiNjliM2... ) Paginated results for AS400 ( https://hibernate.atlassian.net/browse/HHH-16376?atlOrigin=eyJpIjoiNjliM2... ) Change By: Nicolas Chantreau ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a2a370... ) 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. ( https://hibernate.atlassian.net/browse/HHH-16376#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16376#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100219- sha1:ac3e918 )