Oracle Pagination problem

eugenio · **Joined:** Mon Aug 15, 2005 10:02 am **Posts:** 7

Hi,

I am using hibernate 2.1.8 with Oracle 10.
My problem is the same stated by other topics about this subject. The difference between the SQL issued by hibernate for the first page is diferent from other pages, causing some registers to be shown in more than one page:

Code:

select * from (<QUERY>) where rownum <= X

and

select * from ( select row_.*, rownum rownum_ from ( <QUERY> row_ ) where rownum_ <= X and rownum_ > Y

My question is:
1) is there any fix (workaround) in hibernate2 for this?
2) In hibernate 3 this is fixed?