title: apache camel route to split sql results
body: <p>I am trying to do is select all rows from DB, and for each row update some column for that row. Below is my camel route.</p>
  
  <pre><code>from("direct:insert").
  from("sql:select * from my_table").
  split(body()).
  log("${body[id]}").
  end();
  </code></pre>
  
  <p>I use the below code to start this route...</p>
  
  <pre><code>context.createProducerTemplate().sendBody("direct:insert", null);
  </code></pre>
  
  <p>Problem is it happens multiple times (i.e. all the id's from my_table are printed around 18 times!!). How do i make it happen just once?</p>