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.
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.
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.
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.
To commit a change to the database the following steps are needed:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With