title: What is the effect of disabling auto-commit on a database connection?
body: <p>If I set a connection to manual commit does it mean my process will lock the database? If I have to execute multiple SQL queries that might probably take 4-5 hours to execute, does it mean during that time no other user will get to access my database?</p>
  
  <p>I am taking scenario of web application where there are thousands of users accessing same database. </p>
  
  <pre><code>connection.setAutoCommit(false);
  //multiple sql query that will probably take 4-5 hours to be executed
  
  connection.commit();
  </code></pre>