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',
'[email protected]','+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
