Hibernate Community • View topic - How does setFetchSize(int size) work exactly?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How does setFetchSize(int size) work exactly?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

clark98108

Post subject: How does setFetchSize(int size) work exactly?

Posted: Thu May 19, 2005 7:13 pm

Newbie

Joined: Thu Sep 11, 2003 11:49 am
Posts: 8
Location: Albuquerque NM

When applied to a criteria.list() the list size returned is the size of the entire list (ie larger than the fetch size) but there are only as many items as the fetchSize specifies. Are all the elements returned to the jvm or does the database hand back only the elements to the list?

Top

rehdie

Post subject:

Posted: Fri May 20, 2005 1:44 am

Newbie

Joined: Mon Apr 11, 2005 2:08 pm
Posts: 8

hibernate-javadoc of Query#setFetchSize:

Quote:

Set a fetch size for the underlying JDBC query

javadoc of java.sql.ResultSet#setFetchSize:

Quote:

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.

So it depends on the JDBC-Driver, how setFetchSize is handeled.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum