Return-Path: 
 <dev-return-27300-apmail-camel-dev-archive=camel.apache.org@camel.apache.org>
Delivered-To: apmail-camel-dev-archive@www.apache.org
Received: (qmail 41548 invoked from network); 10 Apr 2011 22:01:44 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 10 Apr 2011 22:01:44 -0000
Received: (qmail 79784 invoked by uid 500); 10 Apr 2011 22:01:44 -0000
Delivered-To: apmail-camel-dev-archive@camel.apache.org
Received: (qmail 79717 invoked by uid 500); 10 Apr 2011 22:01:44 -0000
Mailing-List: contact dev-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@camel.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@camel.apache.org>
List-Post: <mailto:dev@camel.apache.org>
List-Id: <dev.camel.apache.org>
Reply-To: dev@camel.apache.org
Delivered-To: mailing list dev@camel.apache.org
Received: (qmail 79709 invoked by uid 99); 10 Apr 2011 22:01:43 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Apr 2011 22:01:43 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED,T_RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Apr 2011 22:01:42 +0000
Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116])
	by hel.zones.apache.org (Postfix) with ESMTP id E73069B32A
	for <dev@camel.apache.org>; Sun, 10 Apr 2011 22:01:05 +0000 (UTC)
Date: Sun, 10 Apr 2011 22:01:05 +0000 (UTC)
From: "Richard Kettelerij (JIRA)" <jira@apache.org>
To: dev@camel.apache.org
Message-ID: 
 <521174680.48119.1302472865943.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <962719272.5761.1300878425778.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Resolved] (CAMEL-3801) Allow to send the Query as a Body +
 Header Message in exchange to the SQL component
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ 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