Set Headers from SQL Result

[labo32]

Hello,

how can I set multiple headers from a sql result set ?

<route>

  <from uri="sql:SELECT name, value FROM configtable"/>

  <split>

       <simple>${body}</simple>

          <setHeader headerName="${body[name]}">

               <simple>${body[value]}</simple>       

          </setHeader>

  </split>

  <to uri="log:headerLog?showHeaders=true"/>

  </route>

does not show any header set (result set returns 2 rows).

Thanks

[davsclaus]

Ah put the log inside the <split>, eg so it becomes

<route>

  <from uri="sql:SELECT name, value FROM configtable"/>

  <split>

       <simple>${body}</simple>

          <setHeader headerName="${body[name]}">

               <simple>${body[value]}</simple>      

          </setHeader>

  <to uri="log:headerLog?showHeaders=true"/>

  </split>

  </route>

[labo32]

But I like to set two or more header informations to use it in a freemarker template and therefore the header informations

must be available after the split.

[davsclaus]

Then you need to use an aggregation strategy on the splitter to merge the data in the message you want to have after the splitter.

A better solution is maybe to use a java bean to set the headers you need. Also headerName= is not dynamic.

[labo32]

Thanks for your answer. I will use a bean to set all my headers.

Is there a reason why headerName= is not dynamic ?

If not - treat my example as a feature request ;-)