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 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.