title: zend adapter beginTransaction() and commit() fails
body: <p>I am facing a strange issue</p>
  
  <p>The Zend_DB_Adapter's beginTrasaction() and commit() methods don't seem to be working as expected. I have INSERT statements (in a FOR LOOP) enclosed in beginTrasaction() and commit() methods. But even when error occurs like below, I still see some rows inserted already, while I was expecting the commiting not to happen since errors occured. I am not able to comprehend why. Can someone help . thanks.</p>
  
  <p>SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'</p>
  
  <p><strong>code block  like:</strong></p>
  
  <pre><code>      **$localDB-&gt;beginTransaction();**
      try{
          echo $localDB-&gt;isConnected();
  
          $localDB-&gt;query("TRUNCATE TABLE $this-&gt;dbTable");
          **foreach ($rowSet as $row){**
              foreach ($row as $key=&gt;$value){
                  $localRow[$this-&gt;columnMap[$key]] =$value;
              }
              **$localDB-&gt;insert($this-&gt;dbTable,$localRow);**
  
          }
  
           $localDB-&gt;commit();
          }
          catch (Exception $e){
          $localDB-&gt;rollBack();
          echo $e-&gt;getMessage();
      }   
  </code></pre>