Hello,
Are you sure that your Jdbc driver does really return a result after executing 
this DML statement?
Some Jdbc drivers do not return this correctly. Maybe do a little manual test 
with your Jdbc drivers do not handle this in a correct way!

Greetings 

Gerald
Von meinem iPhone gesendet

> Am 12.07.2021 um 14:33 schrieb Zuzana Krenkova <zuzana.krenk...@yoso.fi>:
> 
> 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

Reply via email to