[
https://issues.apache.org/jira/browse/CAMEL-8142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14247855#comment-14247855
]
Daniel Pocock commented on CAMEL-8142:
--------------------------------------
When you mention the enricher pattern, do you mean writing a Processor class to
run an SQL query and the result in a header?
What I was really aiming for with this parameter was a way to get things like
querying the next value of a sequence or looking up a primary/foreign key ID
with just one line in the route.
> camel-sql: store query result in header instead of body
> -------------------------------------------------------
>
> Key: CAMEL-8142
> URL: https://issues.apache.org/jira/browse/CAMEL-8142
> Project: Camel
> Issue Type: New Feature
> Components: camel-sql
> Reporter: Daniel Pocock
> Assignee: Claus Ibsen
> Priority: Minor
> Fix For: 2.15.0
>
>
> The SQL component stores query results in the message body, clobbering the
> existing body. It would be nice to store the results of some queries in a
> header.
> This would be particularly useful when combined with outputType=SelectOne to
> store a value such as a primary key / object ID into a header.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
