title: Why set Autocommit to true?
body: <p>I have wondered for a long time why the JDBC API provides an autocommit mode (<code>java.sql.Connection.setAutocommit()</code>). It seems like an attractive nuisance that just lures people into trouble. My theory is it was only added to JDBC in order to simplify life for vendors who wanted to create tools for editing and running SQL using JDBC. Is there any other reason to turn on autocommit, or is it always a mistake?</p>