Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 253
Oliver Avatar asked Jan 13 '17 09:01

Oliver


People also ask

How do I edit a table in DataGrip?

In the Database Explorer (View | Tool Windows | Database Explorer), right-click a table and select Modify Table. In the user field, type the username. You can press Ctrl+Space to use code completion in this field.

How do you commit changes in a database?

You can also commit changes by right-clicking an object, folder, or database in the Object Explorer, and clicking Commit changes to source control. The Commit changes tab is displayed, with the objects you clicked selected to commit.

How do I push DataGrip to github?

DataGrip allows you to upload changes from any branch to its tracked branch or to any other remote branch. Do one of the following: To push changes from the current branch press Ctrl+Shift+K or choose Git | Push from the main menu.


1 Answers

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))
like image 100
Oliver Avatar answered Sep 30 '22 04:09

Oliver