It’s hard to say more about your issue without more information. Can you supply a small sample of your failing route and it’s configuration so that it is possible to check your setup!
Von meinem iPhone gesendet > Am 12.07.2021 um 17:17 schrieb Zuzana Krenkova <zuzana.krenk...@yoso.fi>: > > Yes, within the same application, the JDBC driver will run the insert > correctly and return the values. It is just in the Camel route when nothing > is returned. > >> On 2021/07/12 13:31:26, Gerald Mixa <gerald.m...@gmail.com> wrote: >> 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 >>
