Database tool: submit button doesnt commit inserts in oracle DB (phpstorm 2017.1.3)

hello, I did a connection to oracle and i can run selects and updates with no problem.

But i created a new table and try to insert some data using the grid, then I press the button "Submit" and the data is not saved in the DB.

I do a select in that table and i got empty results.

5 comments
Comment actions Permalink

Please enable Auto-Commit and Auto-Sync in the Oracle driver preferences and try again.

0
Comment actions Permalink

hello, Auto-Sync was already enabled.

I check Auto-Commit and tried, same problem.

I should mention that oracle db is a docker container, but it works fine with my previous IDE and SQL developer 4.0.2.

0
Comment actions Permalink

Could you please share the exact query sample you are using to insert data?

0
Comment actions Permalink

Hello, is not a query, I just use the grid to make changes and commit to the DB.

after submit, I cant see my changes.

0

Please sign in to leave a comment.