Anonymous | Login | Signup for a new account | 12-17-2024 10:48 PST |
Main | My View | View Issues | Change Log | Docs |
Viewing Issue Simple Details [ Jump to Notes ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||||
ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||
0002746 | [Resin] | minor | always | 06-23-08 09:09 | 06-23-08 15:37 | ||||
Reporter | ferg | View Status | public | ||||||
Assigned To | ferg | ||||||||
Priority | normal | Resolution | fixed | ||||||
Status | closed | Product Version | 3.1.6 | ||||||
Summary | 0002746: Amber setMaxResults | ||||||||
Description |
(rep by Riccardo Cohen) I use javax.persistence.Query to retreive entity beans throught the EntityManager. I have to use setFirstResult() and setMaxResults() to implement next page / previous page functions. I found 2 strange things about it : 1) setMaxResults does not fix the "maximum number of results to retrieve" as the docs says, but indeed the last row number to retreive. Example : hqr.setFirstResult(50); hqr.setMaxResults(60); gives : 51 : 51 51 52 : 52 52 53 : 53 53 54 : 54 54 55 : 55 55 56 : 56 56 57 : 57 57 58 : 58 58 59 : 59 59 60 : 60 60 2) the LIMIT sql function seems partially implemented. The previous request calls this :(sql spy=true) select h.adlid, h.adlfirstname, h.adlname from adluser h order by h.adlid LIMIT 60 While it should call LIMIT 50,10 (and actually it should call LIMIT 50,60 if you beleive the javax.persistence.Query doc). It seems that it is the java code that eliminate the 50 first rows. Imagine I want the rows 10000 to 10005, It seems that the database will return 10005 rows and the java code will throw the 10000 first I found nothing about this in recent archives. Thanks for any information about these 2 topics. I use Resin 3.1.5 and also 3.2.0 snapshot 18th mai on MacOsX, the database is mysql 5.0.37 with latest mysql java driver mysql-connector-java-5.1.6-bin.jar |
||||||||
Additional Information | |||||||||
Attached Files | |||||||||
|
Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
28 total queries executed. 25 unique queries executed. |