title: apache-camel - how to access column value of a result set
body: <p>I have a camel route which does a select query from a table, then split the rows, then does something and then update rows of the same table.</p>
  
  <pre><code>  &lt;route&gt;
  &lt;from uri="sql:SELECT ID,NAME,ADDRESS FROM TABLE WHERE SOMECOLUMN = 'Z'?consumer.delay=10000"/&gt;
  &lt;split id="_split1"&gt;
    &lt;simple&gt;body&lt;/simple&gt;
    &lt;!-- DO SOMETHING --&gt;
    &lt;to uri="sql:UPDATE TABLE WHERE ID = {ID FROM DE RESULT QUERY}?consumer.delay=10000"/&gt;
  &lt;/split&gt;
  </code></pre>
  
  <p></p>
  
  <p>How can i access to that column value without java objects?</p>