Lazy select

endlesswinter · **Joined:** Wed Aug 16, 2006 9:54 am **Posts:** 3

Hibernate version:3.1.3

Is there a way to run a query and get the result list as a lazy collection?

MikePloed · **Posted:** Wed Aug 16, 2006 10:05 am

I doubt that this is possible.. Why would you want to do that?

endlesswinter · **Joined:** Wed Aug 16, 2006 9:54 am **Posts:** 3

I would like to get the size of the returned collection using Hibernate Filter, but the same hql later could be used for retrieving the collection itself

pepelnm · **Posted:** Thu Aug 17, 2006 6:15 am

You can get a lazy Iterator.

Interface Query

Code:

public Iterator iterate()

Entities returned as results are initialized on demand. The first SQL query returns identifiers only.

endlesswinter · **Joined:** Wed Aug 16, 2006 9:54 am **Posts:** 3

Iterator is not suitable. Unfortunately, i can't use Iterator to get the size of collection, and i can't create a Filter based on an Iterator.
I also can't use Criteria approach, because my hql is constructed dynamically.

assaf27 · **Joined:** Sun Jan 22, 2006 6:56 am **Posts:** 29

From the hibernate docs:

Quote:

You can find the size of a collection without initializing it:

( (Integer) session.iterate("select count(*) from ....").next() ).intValue();