[ https://issues.apache.org/jira/browse/CAMEL-3801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richard Kettelerij resolved CAMEL-3801. --------------------------------------- Resolution: Duplicate > Allow to send the Query as a Body + Header Message in exchange to the SQL > component > ----------------------------------------------------------------------------------- > > Key: CAMEL-3801 > URL: https://issues.apache.org/jira/browse/CAMEL-3801 > Project: Camel > Issue Type: Improvement > Components: camel-sql > Affects Versions: 2.7.0 > Reporter: Charles Moulliard > Fix For: 2.8.0 > > > The existing SQL component requires that the query is attached to the > endpoint and parameters provided as a List when we would like to replace the > # symbol by those values. > The JDBC component adopts a different philosophy as the query can be build in > a processor, bean or setBody and send to the JDBC endpoint. > Using the following syntax could be much more flexible to setup dynamically > queries : > {code} > <route id="insert-from-file"> > <from uri="file://target/datainsert?moveFailed=failed"/> > <setBody> > <simple>INSERT INTO REPORT.T_INCIDENT (INCIDENT_REF, > > INCIDENT_DATE,GIVEN_NAME,FAMILY_NAME,SUMMARY,DETAILS,EMAIL,PHONE) > VALUES > ('${body}','2011-03-21','Charles','Moulliard','Incident', > 'This is a report incident for webinar-001', > 'cmoulli...@fusesource.com','+111 10 20 300') > </simple> > </setBody> > <to uri="sql"/> > </route> > {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira