IntelliJ IDEA
 
Get IntelliJ IDEA
You are viewing the documentation for an earlier version of IntelliJ IDEA.

Submit changes to a database

Last modified: 10 August 2022

A commit ends a transaction and makes all changes available to other users. In IntelliJ IDEA, you can select how you want to commit transactions: automatically or manually. To change the commit mode, use the Tx drop-down menu on the toolbar.

How changes are committed to a database

The table editor accumulates all the changes that you made. When you press the Submit and Commit button (the Submit button), IntelliJ IDEA sends these changes to a database. In the database, changes are processed according to the selected commit mode:

  • With Tx:Auto, the database itself commits all the changes.

  • With Tx:Manual, changes are stored in a transaction in the database. When you press Submit and Commit (the Commit button), transactions are committed to the database. When you commit the transaction, the Submit and Commit icon (the Commit button) disables (grays out). It means that all the transactions have been committed.

If the commit mode is set to Auto, each change of values, rows, or columns is implicitly committed and cannot be rolled back. In the Auto commit mode, Submit and Commit The Submit and Commit button and Roll back The Rollback button buttons are disabled.

If the commit mode is set to Manual, you can explicitly commit or roll back the submitted changes by clicking Submit and Commit The Commit button or Roll back The Rollback button buttons. To submit changes to a database, click the Submit button The Submit button.

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

Change the transaction level