title: Does @Transactional annotation work if autocommit is true?
body: <p>Would roll back work if auto commit is turned on? if not then what is the implications of turning auto commit off?</p>
  
  <pre><code>@Transactional(rollbackFor = {ManagerException.class})
  public myMethod()....{
      System.out.printLn(my_spring_stored_procedure.getDataSource()
              .getConnection().getAutoCommit()) //true
      ....
      try {
          result = this.my_spring_stored_procedure.execute(params);
      }catch(DataAccessException e){
          throw new ManagerException(e);
      }
  }
  </code></pre>