Transactions are left open and are causing locks on tables (152182)
Transactions are left open and are causing locks on tables
After running a statement in the editor, a transaction is left open and is causing a lock on the table.
Autocommit is turned off.
Turn autocommit on. You can turn autocommit on two ways.
1) Select Autocommit ON or Autocommit OFF in the bottom left hand corner of Toad Data Point.
2) Under Database | General, in the options window, there is an Autocommit field, where it can be set.
Autocommit is set to "ON" by default because some databases have issues leaving transactions open for select statements and Toad Data Point will use the autocommit to clean these up for the user.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.