Forums Register Login

Problem with JPA pagination.

+Pie Number of slices to send: Send
Dear all,

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 ?

Thanks








+Pie Number of slices to send: Send
Sybase is quite different from other databases. Found a thread on this topic.
Seriously Rick? Seriously? You might as well just read this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1890 times.
Similar Threads
help required with pagination
JSTL Pagination for Map inside Map.
jasper-PDF pagination problem
Hibernate pagination performance problem
Pagination Problem
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 01:55:22.