Skip to content
Advertisement

Can’t commit changes to table with Datagrip

I use Datagrip 2016.3. When I try to alter a value in a table, I can’t commit that to the database (a Oracle SQL-DB).

What did I do:
– Setting a cell to /some new value
– Pressing the checkmark icon (‘Commit’)
– AND/OR pressing CTRL+RETURN
– Closing the tab
– Reopen the tab
– The /new value is gone, the old one still is there.

I tried this with different tables on different Schemes (and different databases). The column is nullable, the entered values are legit. I can modify the values with Oracle SQL Developer.

EDIT(20170116):

For most tests after I encountered the problem I tried to change the COUNTRY table of the standard HR schema of a local oracle installation. The same table could be altered with SQL Developer.

Advertisement

Answer

To commit a change to the database the following steps are needed:

  1. Enter a row or change a value (the row is marked green)
  2. Submit the change to database (the arrow icon with “DB”)
  3. Commit that change to the database (auto-commit or right-click for the context menu and select commit (checkmark))
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement