Using TClientDataSet + TDataSetProvider + TIBCQuery leaves the transaction open after opening the TClientDataSet (even if the transaction is closed when the TClientDataSet is opened).
Is this expected behaviour?
TClientDataSet leaves transaction active
-
AndreyZ
Hello,
Yes, it's a designed behaviour of IBDAC. When a dataset is closed, we don't close connections and transactions. To make IBDAC close connections and transactions, you can set the DisconnectedMode option to True. The DisconnectedMode option is used to open a connection for performing a server call only when it's needed, and close a connection after performing the operation. For more information, please read the IBDAC documentation.
Yes, it's a designed behaviour of IBDAC. When a dataset is closed, we don't close connections and transactions. To make IBDAC close connections and transactions, you can set the DisconnectedMode option to True. The DisconnectedMode option is used to open a connection for performing a server call only when it's needed, and close a connection after performing the operation. For more information, please read the IBDAC documentation.