[ 
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

Reply via email to