Page 1 of 1
TClientDataSet leaves transaction active
Posted: Wed 25 May 2011 21:36
by KeitaroBR
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?
Posted: Thu 26 May 2011 12:17
by 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.