tag:blogger.com,1999:blog-12753102.post2354850301768034462..comments2024-03-28T15:41:37.170-04:00Comments on Ben's Journal: Hibernate performance tip: setFetchSizeBen Simonhttp://www.blogger.com/profile/09833753747177544979noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-12753102.post-71412663810689484832014-02-18T23:54:44.194-05:002014-02-18T23:54:44.194-05:00pls help out Hi , i have the stored proc am Calli...pls help out Hi , i have the stored proc am Calling the Stroed Proc with the help of getNamedQuery mehod and am Able to get the result Directly but i want it in form pagination when use <br /> q.setFirstResult(2);<br /> q.setMaxResults(20);<br /> q.setFetchSize(2);<br /> it givving error like Caused by: java.sql.SQLException: ORA-00907: missing right parenthesis i f i doesn't use the Above Thre when i use Direct q.list it will be Fine Wat ui have to Boss Can any one help me OUt<br />Anonymoushttps://www.blogger.com/profile/06577242524338734402noreply@blogger.comtag:blogger.com,1999:blog-12753102.post-25562919588203246232012-07-17T05:07:38.803-04:002012-07-17T05:07:38.803-04:00it worked , thank u very muchit worked , thank u very muchrajivhttps://www.blogger.com/profile/04058601306381473949noreply@blogger.comtag:blogger.com,1999:blog-12753102.post-43518735866437634992010-10-15T13:22:25.016-04:002010-10-15T13:22:25.016-04:00Depending on your fetch mode, the 'bug' mi...Depending on your fetch mode, the 'bug' might have resulted from hibernate handling pagination in memory. See this article: http://java.dzone.com/articles/hibernate-tuning-queries-using<br /><br />Perhaps an easier way to debug this problem would be to look at the hibernate logs rather than debugging the code.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12753102.post-59941476057352718392009-01-26T16:58:00.000-05:002009-01-26T16:58:00.000-05:00I'm so happy to hear this was useful!-BenI'm so happy to hear this was useful!<BR/><BR/>-BenBen Simonhttps://www.blogger.com/profile/09833753747177544979noreply@blogger.comtag:blogger.com,1999:blog-12753102.post-54645201836219188382009-01-25T14:12:00.000-05:002009-01-25T14:12:00.000-05:00I was pulling my hair out over a very large query ...I was pulling my hair out over a very large query I was using. After using your tip it's speed improved 10x. <B>Thanks!</B>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12753102.post-76079261871153237852008-06-11T13:22:00.000-04:002008-06-11T13:22:00.000-04:00Sweet - glad this was helpful.Sweet - glad this was helpful.Ben Simonhttps://www.blogger.com/profile/09833753747177544979noreply@blogger.comtag:blogger.com,1999:blog-12753102.post-24349847972069322142008-06-10T13:03:00.000-04:002008-06-10T13:03:00.000-04:00Awesome. :) I was about to blame MySql and switch ...Awesome. :) I was about to blame MySql and switch to using LIMIT and OFFSET or something silly like that. <BR/><BR/>Thanks alot.Anonymousnoreply@blogger.com