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#4187601 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4187601 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
