The default AutoCommit value (on) is not necessarily bad. This depends on the database system you are connecting to, and how that system handles transactions.
AutoCommit turned on is the natural mode for Sybase and MS-SQL database servers, for example.
Michael
Comment on Re: Re: Multiple Updates with SQL in one connection