Database Systems handle transactions, commits and rollbacks in a variety of ways. These differ between competing database management products from various vendors. So what is the purpose of setting the JDBC Auto-Commit mode, when we know that transaction and commit behavior can be very specific to the actual type of database system we are connecting to.
So when do we want to set Auto-Commit to true and when should we set it to false? And what are the edge cases or pitfalls to look out for?