When working with pooling profiles and the Select operation, the connection remains open until one of the following occurs:
- The flow execution ends
- The content of the streams are consumed completely
- The connection is the transaction key.
Note
Because LOBs are treated as streams, the connection remains open until the flow execution ends, or until the content is consumed before the flow completes, in which case the best approach is taken to close the related connection.
This behavior occurs because the result set the operation generates can have a stream or be part of an ongoing transaction.