query.setFetchSize(int value) is not working as expected.

even though i specify the fetch size, in the above method the query is listing all the results that match the criteria irrespective of fetch size. i din't get exactly how that method is working. can any one of u help me in finding the solution

thnx

hi,

setFetch.. method is used to get some records on specific time.
anyway it will bring all the records. but whtever the input you given
based on it, it will bring the set of records at time instead of bringing all the records at at time.

I mean if you give 15 to the method it wil bring 15 records and it wil keep it in memory.

- dat is the funda...

let me know if my understanding is wrong.

-----------------
dont forget to rate

thts wt i wanna say if i specify 15 as the fetch size it is fetching more than 15 , to be more clear it is fetching all the records from DB taht match the search criteria. but my requirement is to fetch only 15 records, its not working in this way

May be I do not understand what are you trying to accomplish...


If you want to fetch a specific number of records, use
query.setMaxResults(15)

To start at certain offset (30), and bring in next 15 records, use
query.setFirstResult(30);
query.setMaxResults(15);

Do not forget to rate this posting (in case it helped).
Martin.

thanx for ur reply, i already tried query.setMaxResults(int value) and
query.setFirstResult(int value), this is working fine as per the expectations. Im not clear how the method query.setFetchSize(int value) works.Does this method setFetchSize(int value) limits the number of records to be fetched (equal to the argument passed) from DB . To be more specific what is the difference between the two methods

query.setMaxResults(int value ) and query.setFetchSize(int value). I once again thank for ur reply. Any help for this posting is greatly appreciated

thnx

Method setMaxResults(int max) specifies the upper limit on how many rows will your query EVER fetch. For example, if your query could fetch 10,000 rows, and you specify setMaxResults(10), you will get 10 results, period - asking for row 11 will fail.

Method setFetchSize(int value) is a 'hint' to the driver, telling it how many rows it should fetch when it delivered the last row in it's buffer, and your code is asking for more.
For example, if your query could fect 10,000 rows, and you did NOT specify setMaxresult(10), the driver will fetch only setFetchSize() rows, and as your application retrieves those rows, when the first 'chunk' is used up, the driver will go to the database for the next one.
This avoids loading all 10,000 (or more:-) rows at once. However, this is an optimization hint, I remember (long ago) a MySQL driver loading 100,000 rows into memory in one 'chunk'... took a while to run out of memory. Loading more rows in a 'chunk' saves server roundtrips, loading too many rows ... takes up memory.


Plase, rate the posting (if it helped).
Martin.

setFetchSize seems to be necessary at times to work around an issue

http://benjisimon.blogspot.com/2007/...fetchsize.html

Has any one additional comments on that ?