Return-Path: 
 <users-return-35015-apmail-camel-users-archive=camel.apache.org@camel.apache.org>
X-Original-To: apmail-camel-users-archive@www.apache.org
Delivered-To: apmail-camel-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id EFBAAE5BD
	for <apmail-camel-users-archive@www.apache.org>;
 Tue, 18 Dec 2012 17:05:40 +0000 (UTC)
Received: (qmail 78622 invoked by uid 500); 18 Dec 2012 17:05:40 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 78592 invoked by uid 500); 18 Dec 2012 17:05:40 -0000
Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@camel.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@camel.apache.org>
List-Post: <mailto:users@camel.apache.org>
List-Id: <users.camel.apache.org>
Reply-To: users@camel.apache.org
Delivered-To: mailing list users@camel.apache.org
Delivered-To: moderator for users@camel.apache.org
Received: (qmail 95368 invoked by uid 99); 18 Dec 2012 16:09:38 -0000
X-ASF-Spam-Status: No, hits=2.0 required=5.0
	tests=SPF_NEUTRAL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: 216.139.236.26 is neither permitted
 nor denied by domain of sathiyaprabu@gmail.com)
Date: Tue, 18 Dec 2012 08:09:10 -0800 (PST)
From: sprabu <sathiyaprabu@gmail.com>
To: users@camel.apache.org
Message-ID: <1355846950657-5724291.post@n5.nabble.com>
Subject: How do i read the xml element values from the xml payload and have
 to pass those values to sql query.
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,
I'm getting messages from route and want to insert xml payload values in
sql. 
<from uri=queue:com.test.Queue1>
<to uri="sql:insert into MY_TABLE
values(${in.header.MessageId},//Element1,//Element2)" />
....

Also i want to pass the jms message id to the sql query. 
How do i read the xml element values from the xml payload and have to pass
those values to sql query?
This should be done in the spring xml dsl.

Thanks in advance.



--
View this message in context: http://camel.465427.n5.nabble.com/How-do-i-read-the-xml-element-values-from-the-xml-payload-and-have-to-pass-those-values-to-sql-query-tp5724291.html
Sent from the Camel - Users mailing list archive at Nabble.com.