{question}
Is it possible for a result set to be held open after the transaction has been committed?
{question}
{answer}
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 HOLD_CURSORS_OVER_COMMIT
.
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.
{answer}
Comments