Intellij database cannot create new row

Using IntelliJ 14.0.3, whenever I try to create a new row inside a database table, the editor simply creates a new row with default values ​​for each column. Then I edit these default values ​​with the actual values. After updating, the line then disappears. Auto commit is on.

Edit: Also happens in IntelliJ IDEA 14.1.1. Even when Auto-Commit is turned off, after creating the line, edit the values, then click on the "Commit" button, it has not yet been saved.

+5
source share
1 answer

After you filled in the new values, you need to call the action "Send a new row" - it is available in the context menu of the inserted row.

The fact is that after you click "Add a new line", a new line is added only to the user interface, so you can edit the values. The action "Send a new line" represents a new line for your dbms, "Commit" captures the current database transaction.

+9
source

Source: https://habr.com/ru/post/1215214/


All Articles