Hi Fabrizio
here's what is wrong with your example:
- "<to uri="jdbc://mysql" />" means you're using JDBC component, not SQL
component
- so you should use <setHeader headerName="CamelRetrieveGeneratedKeys">,
not <setHeader headerName="CamelSqlRetrieveGeneratedKeys">
- you should also use
"<simple>${in.headers.CamelGeneratedKeysRows}</simple>", not
"<simple>${out.header.CamelSqlGeneratedKeyRows}</simple>" because generated
keys stored in "out" are available in "in" of the next processor
- add "<to uri="log:generated keys?showAll=true&multiline=true" />"
after <setBody> to see:
[ qtp1540453036-19] generated keys INFO
Exchange[
...
*, Body: [{GENERATED_KEY=12}]*
...
]
regards
Grzegorz
2015-01-08 16:16 GMT+01:00 Claus Ibsen <[email protected]>:
> Hi
>
> See this FAQ
> http://camel.apache.org/using-getin-or-getout-methods-on-exchange.html
>
> Rule of thumb, dont use out.
>
> On Thu, Jan 8, 2015 at 3:37 PM, fabrizio.spataro
> <[email protected]> wrote:
> > Hello,
> >
> > So.. is it a bug? I haven't any information about generated keys (OUT
> > Message is null)
> >
> > this is my code:
> >
> > <spring DSL>
> >
> > <camel:camelContext xmlns="http://camel.apache.org/schema/spring";>
> > <camel:restConfiguration bindingMode="auto" component="jetty"
> > host="0.0.0.0" port="8080"/>
> > <camel:rest path="/api">
> > <camel:get uri="/doIt" produces="application/json">
> > <camel:route>
> > <setHeader headerName="CamelSqlRetrieveGeneratedKeys">
> > <constant>true</constant>
> > </setHeader>
> > <setBody>
> > <constant>
> >
> > insert into company (id,
> name, description, email) values (0,
> > 'myName', '', '[email protected]')
> > </constant>
> > </setBody>
> > <to uri="log:executing
> query?showAll=true&multiline=true"/>
> >
> > <to uri="jdbc://mysql" />
> >
> > <setBody>
> >
> <simple>${out.header.CamelSqlGeneratedKeyRows}</simple>
> > </setBody>
> > </camel:route>
> > </camel:get>
> > </camel:rest>
> >
> > </camel:camelContext>
> >
> > I had attach full example code package RetrieveGeneratedKey.zip
> > <
> http://camel.465427.n5.nabble.com/file/n5761460/RetrieveGeneratedKey.zip>
> >
> >
> >
> > --
> > View this message in context:
> http://camel.465427.n5.nabble.com/SQL-COMPONENT-CamelSqlGeneratedKeyRows-has-a-bug-tp5761113p5761460.html
> > Sent from the Camel - Users mailing list archive at Nabble.com.
>
>
>
> --
> Claus Ibsen
> -----------------
> Red Hat, Inc.
> Email: [email protected]
> Twitter: davsclaus
> Blog: http://davsclaus.com
> Author of Camel in Action: http://www.manning.com/ibsen
> hawtio: http://hawt.io/
> fabric8: http://fabric8.io/
>
