title: JDBC connection default autoCommit behavior
body: <p>I'm working with JDBC to connect to Oracle. I tested <code>connection.setAutoCommit(false)</code> vs <code>connection.setAutoCommit(true)</code> and the results were as expected. </p>
  
  <p>While by default connection is supposed to work as if <code>autoCommit(true)</code> [correct me if I'm wrong], but none of the records are being inserted till <code>connection.commit()</code> was called. Any advice regarding default behaviour?</p>
  
  <pre><code>String insert = "INSERT INTO MONITOR (number, name,value) VALUES (?,?,?)";
  
  conn = connection; //connection  details avoided
  preparedStmtInsert = conn.prepareStatement(insert);
  preparedStmtInsert.execute();
  
  conn.commit();
  </code></pre>