Hi,

I am trying to fetch around 4-20 mn rows using a sys_refcursor (Oracle 10g ) and multiple java threads (each specifies a rownum range for the cursor query). I am also using the Hibernate ORM feature - ResultTransformer to bind it to a non-entity for subsequent processing and flushing to text files. I do evict the list flushed to files periodically along with the foll settings:

session.setCacheMode(CacheMode.IGNORE);
session.setFlushMode(FlushMode.MANUAL);

Do you foresee any issue with this - especially OOM related?


Any ideas or alternatives?

Thanks..

I am able to accomplish that using ScrollableResults and ScrollMode.SCROLL_INSENSITIVE..
I would assume that query.list() in context of the SYS_REFCURSOR with a non-entity mapped through ResultTransformer would do something similar.
Basically, what I am expecting here is to do a
sqlQuery.list() on a query that returns a sys_RefCursor, assuming that the list is a proxy and progressively, hibernate will fetch records from the DB as I Iterate over the list. Even with periodic eviction, I keep getting OOM's.


Any suggestions?

Thanks..