DBeaver supports two modes for committing changes to the database:

  • Auto-commit transfers all changes that you make immediately to the database.
  • Manual commit requires your confirmation before committing a change to the database or rolling it back.
    Though available in many cases, the two modes are actionable only in SQL Editor. See the next sections for details of using the modes.

To switch between the modes, use the mode selection button that appears in one of the two views: Auto and Manual Commit Modes - 图1 or Auto and Manual Commit Modes - 图2.

Auto-Commit Mode

Auto-commit mode is the default one for the Development and Test connection types, see Connection Types. Auto-commit mode is on if you can see the auto-commit view of the mode selection button (Auto and Manual Commit Modes - 图3 in the application toolbar. If you see the manual commit view (Auto and Manual Commit Modes - 图4), then in order to switch to auto-commit mode, click the mode selection button – it changes to auto-commit. At the same time, this disables the two manual commit buttons in the toolbar: Commit and Rollback – these are available only in manual commit mode.

The statistics field next to the mode selection button always shows Auto in auto-commit mode: Auto and Manual Commit Modes - 图5.

Clicking the statistics field opens the Transaction Log.

Manual Commit Mode

Manual commit is intended to protect your database from inadvertent changes and that is why it is the default mode for Production connection type, see Connection Types.

Manual commit mode is on if you can see the Manual commit view of the mode selection button (Auto and Manual Commit Modes - 图6 in the application toolbar. If you see the auto-commit view (Auto and Manual Commit Modes - 图7), then in order to switch to manual commit mode, click the auto-commit button – it changes to manual commit. At the same time, this enables the two manual commit buttons in the toolbar: Commit (Auto and Manual Commit Modes - 图8 and Rollback (Auto and Manual Commit Modes - 图9).

In manual commit mode, when you execute SQL statements (Ctrl+Enter), the number of database modifying statements that pend commitment to the database appears in the statistics field next to the mode selection button: Auto and Manual Commit Modes - 图10.

If you hover you mouse over the field, you can see statistics of your SQL statements:

Auto and Manual Commit Modes - 图11

To commit statements to the database, click the Commit button in the toolbar. To discard them, click Rollback.

If no modifying statements have been made, the statistics field shows None: Auto and Manual Commit Modes - 图12

Clicking the statistics field opens the Transaction Log.

Transaction Isolation Level

For both, Auto and Manual commit modes, you can select the transaction isolation level. To do so, click the arrow next to the mode icon and then click the required option in the dropdown list:

Auto and Manual Commit Modes - 图13