ResultHandler - OutOfMemory Exception

2009-09-14 Thread K. Arnold
I am trying to iterate over a result set of 2million records, for a large bulk load and transformation into a new ODS. It appears that I am getting an OutOfMemoryException because the DefaultResultSetHandler is caching the object in the nestedResultObjects property. Is there some property I shou

Re: ResultHandler - OutOfMemory Exception

2009-09-14 Thread Clinton Begin
The nestedResultObjects is necessary for join mapping. One way to deal with this though, is to use batches of reads as well as writes. Use the pagination facilities and possibly even the proprietary offset/limit features of your database to grab subsets of the results. Incidentally I'm rewriting