title: How to set autocommit false in apache camel sql batch insertion?
body: <p>I am using apache-camel sql-batch insertion.
  My route for sql batch insertion is as follows:</p>
  
  <pre><code>&lt;pipeline&gt;
     &lt;transform&gt;
        &lt;method ref="insertionMyBean" method="myBatchInsertion"&gt;&lt;/method&gt;
     &lt;/transform&gt;
     &lt;choice&gt;
         &lt;when&gt;
             &lt;simple&gt;${in.header.myCount} == ${properties:batch.mySize}&lt;/simple&gt;
             &lt;to uri="sql:{{sql.subs.insertMyBatchStatement}}?batch=true"&gt;&lt;/to&gt;
             &lt;log message="Inserted rows ${body}"&gt;&lt;/log&gt;
         &lt;/when&gt;
     &lt;/choice&gt;
  &lt;/pipeline&gt;
  </code></pre>
  
  <p>I want to configure autocommit false for this route.
  Can anybody help me out with this?
  FYI...When i use mybatis for batch insertion, autocommit is set false by the mybatis framework. How can i do the same when using plane sql?</p>