i found that Oracle9iDialect user different sql to implement the paging query between the first page(without offset) and the afters. When query for the first page, the sql is "select * from (inner orderSql) where rownum < ?", but in fact ,i think this sql will not certainly select the first rows of the ordered results, is there any operation i skipped at the paging select ? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4187601#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...