my dog learned polymorphism*
The moose likes Object Relational Mapping and the fly likes Problem with JPA pagination. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Problem with JPA pagination." Watch "Problem with JPA pagination." New topic
Author

Problem with JPA pagination.

Narendra Dhande
Ranch Hand

Joined: Dec 04, 2004
Posts: 950
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









Narendra Dhande
SCJP 1.4,SCWCD 1.4, SCBCD 5.0, SCDJWS 5.0, SCEA 5.0
T Mishra
Ranch Hand

Joined: Apr 04, 2006
Posts: 108

Sybase is quite different from other databases. Found a thread on this topic.


Thanks,
Tushar (SCJP 1.5)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem with JPA pagination.
 
Similar Threads
Pagination Problem
Hibernate pagination performance problem
jasper-PDF pagination problem
help required with pagination
JSTL Pagination for Map inside Map.