I am using JPA layer from application development. The environment is tomcat 7, Hibernate 4.1.4 and database is Sybase ASE 15.7 Developer edition. The JPA context is built using Hibernate. I am trying the pagination Query, but it is giving the strange results.
The JPA Query is :
The Query in the dao is
The execution is
There are 36 records in the sybase table. the Ids are primary key and the field is IDENTITY.
The Result is
The Query 1 and Query 2 shows the correct results, but after that the query generating the same result for next offsets.
Please help to sort out the problem. Any Sybase specific setting are required ?