Report the camel version, please
Il mer 23 mar 2022, 09:59 Reto Peter ha scritto:
> Hi
>
> I have a route with 2 following SQL INSERT commands.
> One inserts into table A (CamelSqlGeneratedKeyRows is correct)
> Next inserts into table B (CamelSqlGeneratedKeyRows is wrong, the value is
> not upda
Ya sorry.
Camel version: 3.15.0
On 23 March 2022 17:03:19 Andrea Cosentino wrote:
Report the camel version, please
Il mer 23 mar 2022, 09:59 Reto Peter ha scritto:
Hi
I have a route with 2 following SQL INSERT commands.
One inserts into table A (CamelSqlGeneratedKeyRows is correct)
Next inse
FYI, I think I worked around this by removing the CamelSqlGeneratedKeyRows
header prior to a sql call.
On Wed, Mar 23, 2022 at 4:42 AM Reto Peter wrote:
> Ya sorry.
> Camel version: 3.15.0
>
> On 23 March 2022 17:03:19 Andrea Cosentino wrote:
>
> Report the camel version, please
>
> Il mer 23 m
Hi
a)
Can you try with just 1 sql insert,
.to("sql:INSERT INTO message_out(identifier) VALUES (1)")
It may be that this SQL does not return any generated keys
b)
Can you try to set the header to get keys before calling the 2nd insert
.setHeader("CamelSqlRetrieveGeneratedKeys").simpl
@camel.apache.org
Subject: Re: CamelSqlGeneratedKeyRows is not updated
Hi
a)
Can you try with just 1 sql insert,
.to("sql:INSERT INTO message_out(identifier) VALUES (1)")
It may be that this SQL does not return any generated keys
b)
Can you try to set the header to get keys before c
Header before first statement and before second statement but
> no change.
>
> -Original Message-
> From: Claus Ibsen
> Sent: Thursday, March 24, 2022 3:51 AM
> To: users@camel.apache.org
> Subject: Re: CamelSqlGeneratedKeyRows is not updated
>
>
et the keys back if I only run the 2nd select
b) I set the Header before first statement and before second statement but
no change.
-Original Message-
From: Claus Ibsen
Sent: Thursday, March 24, 2022 3:51 AM
To: users@camel.apache.org
Subject: Re: CamelSqlGeneratedKeyRows is not updated
Hi
gt; a) it works as normal, I get the keys back if I only run the 2nd select
> >> b) I set the Header before first statement and before second statement
> but
> >> no change.
> >>
> >> -Original Message-
> >> From: Claus Ibsen
> >&