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
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