how do query.list() use cache?

tornadojava · **Joined:** Mon Aug 07, 2006 9:51 pm **Posts:** 3

I know Query.iterator() use cache,but I don't konw Query.list() how use cache.

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Same way. Query.iterator() = Query.list().iterator().

tornadojava · **Joined:** Mon Aug 07, 2006 9:51 pm **Posts:** 3

I see.
I didn't like iterator.Because it load recorders one by one.

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Ah, I see what you mean. Query.iterator() uses scrollable result sets if it can, allowing you to defer loading. Query.list() will load all entities that you query for, before the call to list() returns. It won't do anything special about eagerly loading associated entities: you have to write your query to do that, if that's what you need.

tornadojava · **Joined:** Mon Aug 07, 2006 9:51 pm **Posts:** 3

thanks very much.

Tank · **Joined:** Sat Aug 05, 2006 2:49 am **Posts:** 3

tenwit wrote:

Ah, I see what you mean. Query.iterator() uses scrollable result sets if it can, allowing you to defer loading. Query.list() will load all entities that you query for, before the call to list() returns. It won't do anything special about eagerly loading associated entities: you have to write your query to do that, if that's what you need.

Maybe you can help answer a somewhat related issue I'm having. When I call Query.list(), I get a collection back, but the elements in the collection are null... I haven't been able to figure out how to resolve this for almost a week.

Any advice is appreciated!

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Post your mapping. Possibly in a new topic.