Hi Zuzana, have you set the `CamelSqlRetrieveGeneratedKeys=true` header? See the documentation on that:
https://camel.apache.org/components/latest/sql-component.html#_generated_keys zoran On Mon, Jul 12, 2021 at 2:33 PM Zuzana Krenkova <[email protected]> wrote: > > Is it possible to use PostgreSQL insert with returning clause with Camel sql > component? This insert statement works fine on its own (inserting and also > returning id and token), but when used in a Camel route, the insert gets > processed but exchange body is returned empty. Why? > > INSERT INTO my_table(token) values(:#new_token) > ON CONFLICT (token) > DO UPDATE SET token=excluded.token returning id, token -- Zoran Regvart
