You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@camel.apache.org by "Charles Moulliard (JIRA)" <ji...@apache.org> on 2011/03/23 12:07:05 UTC
[jira] [Created] (CAMEL-3801) Allow to send the Query as a Body +
Header Message in exchange to the SQL component
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',
'cmoulliard@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
[jira] [Resolved] (CAMEL-3801) Allow to send the Query as a Body +
Header Message in exchange to the SQL component
Posted by "Richard Kettelerij (JIRA)" <ji...@apache.org>.
[ 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',
> 'cmoulliard@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