if the result set is very big , for example ,1G data ,we used getResultList, Easily machine will out of memory, so in hibernate we can used Query.iterater to avoid out of memory ,but if we use only jpa , Query.iterater is not available, it seemed that we can use getResultList only, how to resolve the problem:out of memory.

Of course ,we can use paged query or use jdbc, but I think sometimes it's not a good idea, any other resolution?

I think many of us will face such a problem,I wonder how others solve it?

ScrollableResults, maybe?

o, but it is not belong to JPA , I hope to be solved with JPA, so I can transplant to toplink or other jpa tool later .