Search code examples
sqloracle-databasedatagrip

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.

Solution

  • 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))