IntelliJ IDEA 2018.3 Help

Submitting changes to a database

Submit changes manually

By default, changes in tables are not submitted automatically. At first, you make changes in your local copy of the table, then you need to submit all changes to a database.

To submit changes to a database, click the Submit icon (The Submit icon), or pressCtrl+Enter.

Submit changes automatically

By default, changes are not submitted to a database unless you press the Submit icon (The Submit icon), or pressCtrl+Enter. You can enable the Submit changes immediately option to submit your changes automatically.

  1. In settings (Ctrl+Alt+S), navigate to Database | Data Views.

  2. Select Submit changes immediately.

  3. Click OK.

Submit changes by using database transactions

You can select to commit transactions automatically or manually. To change the commit mode, use the Tx drop-down menu on the toolbar.

Change the transaction level

If you submit a change to the database server and the commit mode is set to Auto, each change of values, rows, or columns is implicitly committed and cannot be rolled back.

If the commit mode is set to Manual, you can explicitly commit or roll back submitted changes by means of the Commit icon (The Commit icon) or the Rollback icon (The Rollback icon). Otherwise, select Commit (Ctrl+Shift+Alt+Enter) or Rollback commands from the context menu.

The Tx switch can also be used for selecting the isolation level for the transactions.

Revert changes

Before you submit the changes, you can revert them.

The scope of the revert command is defined by the current selection in a table: the command is applied only to the changes within the selection. So you can revert an individual change, a group of changes or all the changes. If nothing is currently selected, the revert command is applied to the whole table.

To revert non-submitted changes, select and right-click a cell or a number of cells. Select Revert Selected (Ctrl+Alt+Z).

Last modified: 1 February 2019