I am connecting to the DB2 database using oracle SQL developer, but automatically it is committing, i checked in the advanced menu the auto commit feature is turned off. I am confused now, can someone help me in switching off auto commit.
1 Answer
Check whether auto-commit is really off (or if it's a glitch in the gui), by (for example):
1. create table T (x int);
2. rollback;
3. select * from t; -- should result in an error
answered Oct 28, 2019 at 14:26
-
-
Then autocommit is on regardless of what the gui says Oct 28, 2019 at 15:24
-
What happens if you enable auto-commit, and then disable it again? Oct 28, 2019 at 19:06