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
> >&
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
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
>
>
@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
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
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
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
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
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
updated, it remains the same)
I am using mySQL and Java 11
My simplified route:
fro
