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