Hi Ronny, from what I can see from the SqlProducer source code the body is set if the PreparedStatement::execute method returns `true`[1]. I could be reading this wrong, but to me it seems that you're using insert/update statement that does not return a ResultSet, so in that case the body will be null.
Some databases support a feature called data change tables (well, DB2 and MSSQL at least), so you could do something like: `SELECT FROM FINAL TABLE (INSERT ...)` in MariaDB?. But if you wanted the same message delivered to multiple endpoints, perhaps you are looking for the recipient list EIP[2]? zoran [1] https://github.com/apache/camel/blob/master/components/camel-sql/src/main/java/org/apache/camel/component/sql/SqlProducer.java#L161 [2] https://camel.apache.org/recipient-list.html On Fri, Mar 31, 2017 at 10:56 AM, Ronny Aerts <ronny.ae...@intris.be> wrote: > Hello integrations community, > > I have a route (camel 2.17.6) where I need to insert a record into a MariaDB > database and I need to capture the generated id of the record. I therefore > set the CamelSqlRetrieveGeneratedKeys header to true. The record is inserted > correctly and the id generated BUT the content of the body becomes null. How > can I prevent to have the null AND returning the keys? > > The body is not cleared when I don't set the CamelSqlRetrieveGeneratedKeys > header but then I don't have the id of the record. > > I already tried with the outputHeader and noop=true but this didn't help. > > -- > kind regards, > Ronny Aerts<mailto:ronny.ae...@intris.be> - Intris nv - Wapenstilstandlaan > 47, 2600 Berchem, België > Product Owner Integrations / Integrations Manager > Prince II<http://nl.wikipedia.org/wiki/PRINCE2> certified - > ITIL<http://nl.wikipedia.org/wiki/Information_Technology_Infrastructure_Library> > certified > Tel: +32-3-326.50.75 > > [https://s19.postimg.org/3pi2w9i2b/BBEU_email_Intris_nv.jpg]<http://www.breakbulk.com/events/breakbulk-europe/breakbulk-europe-2017/register/> > > <http://www.breakbulk.com/events/breakbulk-europe/breakbulk-europe-2017/register/> > > > Intris nv > Wapenstilstandlaan 47 > B-2600 Berchem Tel. +32 3 326 50 75 > Fax +32 3 326 42 23 > www.intris.be<http://www.intris.be/> > DISCLAIMER > This is an e-mail from Intris. The information contained in this > communication is intended solely for use by the individual or entity to whom > it is addressed. > Use of this communication by others is prohibited. If the e-mail message was > sent to you by mistake, please notify > supp...@intris.be<mailto:supp...@intris.be>, destroy it without reading, > using, copying or disclosing its contents to any other person. > We accept no liability for damage related to data and/or documents which are > communicated by electronic mail. -- Zoran Regvart
