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:
- Enter a row or change a value (the row is marked green)
- Submit the change to database (the arrow icon with “DB”)
- Commit that change to the database (auto-commit or right-click for the context menu and select commit (checkmark))