Once you have made some changes, a message at the bottom of the screen will warn you of this. It is highly recommended that you Commit or Rollback promptly and do not leave uncommitted changes for any length of time.
if you are using the option Disconnect if Idle, the Disconnect may fail if there are uncommitted changes. If so, you will remain connected to the database.
if AQT crashes, or looses communication with the server, the results can be unpredictable. See AQT Closes without Committing Changes below.
before you close a database, or shut down AQT, you will be prompted to Commit your changes.
It is highly recommended that you click Yes to Commit.
Only click No if Commit fails. This might be the case, for instance, if your machine has lost contact with the database due to communication or other problem.
Clicking No will terminate AQT with either Committing or Rolling Back the changes. Only use this if all other options do not work. See the next section.
AQT Closes without Committing Changes
This can happen if:
you have uncommitted changes and AQT either crashes or looses communication with the server
when disconnecting from the database, you select the No option.
In this case, most databases will automatically rollback the outstanding changes. You will have lost any work you have done.
In some circumstances, the AQT process can remain in a suspended state on Windows if is has not terminated cleanly. In this case, it will continue to hold locks and may interfere with other tasks on the database. This may require a DBA to terminate the task on the server.
Other Notes on Transactions
if you are doing a large or critical change to your database, it is a good idea to run the change as a transaction. The ability to undo the change can be very useful should the change not do what you want!!
once you have run your SQL, you do not need to decide immediately whether to commit or rollback. You can display the table and run queries to determine whether your change has had the desired effect. Once you have determined this, you can choose whether to commit or rollback.
Note that you should display the table using the same AQT session and connection as the one that made the change. If you display the data using a different AQT connection you may or may not see the unchanged version of the data.
while your transaction is active, the rows you have changed in the database are locked and cannot be updated by other users. In some circumstances, other users will not even be able to display the data. You should not leave your transaction active for any longer than you need to.
If your transaction is active, and your PC or connection to the database fails, your changes will be rolled back. Once you have determined that your changes are OK, you should Commit immediately!
there are number of limitations of transactional control
some databases do not have the ability to rollback DDL statements (Create, Drop, Alter etc). These changes will be run outside of transactional control.
some statements (for instance Oracle Truncate) cannot be rolled back.