[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Help for Oracle9iDialect's getLimitString method, is there a

[iooyoo]

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