Matthias Glasel The fix in HHH-11747 Resolved doesn't add the OFFSET native support from your link but instead reverts back to the behavior exhibited by Hibernate 4 where the result-set basically selects the necessary rows using FETCH FIRST X ROWS ONLY and then advances the result-set to the starting point based on the supplied setFirstResult value. To add actual OFFSET support for DB2, we should open an enhancement request for that.