Is it possible for a result set to be held open after the transaction has been committed?
Yes, it is possible.
ResultSet operations are supported by NuoDB's Spill to Disk feature.
In order to prevent the result set from being closed, set the
holdability property to
As a result of using the
HOLD_CURSORS_OVER_COMMIT value, the result set is materialized in-memory. To facilitate queries with result sets that exceed memory available, NuoDB provides Spill to Disk capability. If Spill to Disk is enabled and the result set exceeds the "
DISKSPILL_MEMORY_THRESHOLD_MB" value then the result set will be written to the disk on the TE (Transaction Engine).
For more information on Spill to Disk in NuoDB, see Spill to Disk.