java - My DML queries are not affecting row in Oracle DB?

Question

I have an application that works as expected and I can insert/update the rows through application. But when I connect to my oracle database through SQL Developer and tried to run the UPDATE query, I get message that 1 row is updated. while the row is not updated.

Also the user I used to connect oracle database is same for both Application and SQL Developer with having insert and update privileges.

I feel a transparency Layer is implemented in oracle database that blocks the direct query execution. Can anyone knows how this feature is implemented or which oracle product is configured?

Answer 1

After DML, you will have to commit the transaction to make actual changes in the database.

Without commit, you will see the changed data in current session but other sessions will not be able to see that changes. Or you can say, it is not actually changed in database too without commit.