title: Auto-COmmit of DDL
body: <p>I read that "CREATE TABLE" and "DROP TABLE" statements are auto-commit. I am trying to understand their behaviour for the below scenario:</p>
  
  <pre><code>conn.setAutoCommit(false);
  stmt = conn.createStatement("CREATE TABLE ...");
  
  conn.commit();
  </code></pre>
  
  <p>In the above case, would setting autoCommit to false would have any impact on CREATE TABLE auto-commiting. If conn.setAutoCommit(false) does override DDL auto-commit property, then whats the entire point, because by default a new connection is in auto-commit mode.</p>
  
  <p>I believe except MySQL and older versions of ORacle, most major RDBMS allow DDL rollback. My questions concerns If in MySQL DDL rollback is not allowed, what is point of setting auto-commit of connection to false for DDL operations?</p>
  
  <p>I will really appreciate your opinion in clarifying my doubts.</p>