title: spring ibatis mysql intermittent asynchronous problem
body: <p>I'm using ibatis in spring to write to mysql.</p>
  
  <p>I have an intermittent bug. On each cycle of a process I write two rows to the db. The next cycle I read in the rows from the previous cycle. Sometimes (one time in 30, sometimes more frequently, sometimes less) I only get back one row from the db. </p>
  
  <p>I have turned off all caching I can think of. My sqlmap-config.xml just says:</p>
  
  <pre><code>&lt;sqlMapConfig&gt;
  &lt;settings enhancementEnabled="false" statementCachingEnabled="false" classInfoCacheEnabled="false"/&gt;
  
  &lt;sqlMap resource="ibatis/model/cognitura_core.xml"/&gt;
  </code></pre>
  
  <p></p>
  
  <p>Is there some asynchrony, or else caching to spring or ibatis or the mysql driver that I'm missing?</p>
  
  <p>Using spring 3.0.5, mybatis 2.3.5, mysql-connector-java 5.0.5</p>
  
  <p>EDIT 1:</p>
  
  <p>Could it be because I'm using a pool of connections (c3p0)? Is it possible the insert is still running when I'm reading. It's weird, though, I thought everything would be occuring synchronously unless I explicitly declared asynch?</p>