MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: rollback and commit when calling connection.close
Posted by: W Che
Date: August 27, 2012 10:27PM

More Info: I just ran the followings on version 5.1.58:

set autocommit=0;
insert into user(id, username) values(1000,'me');
rollback;

after rollback, the new user1000 is still in the table. It looks like autocommit setting is always true even with 'set autocommit=0'. Is this caused by some config or am I missing something here?

Thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
rollback and commit when calling connection.close
W Che
August 27, 2012 06:26PM
Re: rollback and commit when calling connection.close
W Che
August 27, 2012 10:27PM
Re: rollback and commit when calling connection.close
Barry Galbraith
August 27, 2012 11:09PM
Re: rollback and commit when calling connection.close
W Che
August 28, 2012 07:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.