setFetchSize Ignored

mardigrasboy · **Joined:** Fri Dec 03, 2004 4:41 pm **Posts:** 15

Hibernate version:
2.1.7

Name and version of the database you are using:
Oracle 9

I'm using the createQuery and setFetchSize(10). I'm stilling getting over a thousand items for the call list(). Is there a reason for that?

michael · **Posted:** Mon Feb 14, 2005 12:32 pm

Check the generated query, and if that does not help post more information (your code, for example)

mardigrasboy · **Joined:** Fri Dec 03, 2004 4:41 pm **Posts:** 15

There's nothing unusual in the generated sql. I would assume setFetchSize is a internal call to limit the size of the list. Is there anything I should be looking for?

emmanuel · **Posted:** Mon Feb 14, 2005 12:37 pm

fetchSize is related to the result set filling strategy.
Use setMaxResult to limit your query.

michael · **Posted:** Mon Feb 14, 2005 12:41 pm

Ah, I didn't read properly. Please read the API.

emmanuel · **Posted:** Mon Feb 14, 2005 12:45 pm

michael wrote:

Ah, I didn't read properly. Please read the API.

ROTFL, I didn't read, please read ;-)

michael · **Posted:** Mon Feb 14, 2005 12:46 pm

mardigrasboy · **Joined:** Fri Dec 03, 2004 4:41 pm **Posts:** 15

Thanks, using setMaxResult now. Does setFetchSize even do anything in Oracle 9 flavor?