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 >
