Return-Path: 
 <users-return-52350-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 3503710B38
	for <apmail-camel-users-archive@www.apache.org>;
 Sat, 22 Nov 2014 21:35:52 +0000 (UTC)
Received: (qmail 93921 invoked by uid 500); 22 Nov 2014 21:35:51 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 93870 invoked by uid 500); 22 Nov 2014 21:35:51 -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
Received: (qmail 93858 invoked by uid 99); 22 Nov 2014 21:35:51 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Nov 2014 21:35:51 +0000
X-ASF-Spam-Status: No, hits=2.8 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of davidkarlsen@gmail.com
 designates 209.85.214.175 as permitted sender)
Received: from [209.85.214.175] (HELO mail-ob0-f175.google.com)
 (209.85.214.175)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Nov 2014 21:35:46 +0000
Received: by mail-ob0-f175.google.com with SMTP id wp4so5644321obc.34
        for <users@camel.apache.org>; Sat, 22 Nov 2014 13:34:41 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=ySHvqNmxFBeceMi/QfBPkIPFsjpGocF+B9zM6Sf+0TA=;
        b=UEZULLV8W4ER3QH5A/MVyZ/Zf4YiefITpaHKH8xRc3YaP9wxtMlFaVPdsw8yxDqHtH
         LpH2JCCCEm6X/R5gSH1G85x5dJImnA9OT4pGC8u1O0o56hac8oTMYfwSGliyLJhkce4K
         eOZh6B92Ar/JoPfk74Gl9mmDyIm+WhuUggew5KyUoDW0f5MiBGSSWwFf331xBfb+PKb/
         FLHHzF2WQk7+WhdBWnVT4JE0UDI7yYLgSPaFRvm/e8JyPzUCRhFK6ia1+rU4JSG9L4Nf
         wOovvX3wk+pIyi8U3oTMC+Ts9YCrLPw5Vr6kX1NoXVIRAfx4ctLTBp/7+aa4wVNPsXi8
         S4+Q==
MIME-Version: 1.0
X-Received: by 10.182.205.164 with SMTP id lh4mr7412646obc.5.1416692080886;
 Sat, 22 Nov 2014 13:34:40 -0800 (PST)
Received: by 10.60.81.3 with HTTP; Sat, 22 Nov 2014 13:34:40 -0800 (PST)
Received: by 10.60.81.3 with HTTP; Sat, 22 Nov 2014 13:34:40 -0800 (PST)
In-Reply-To: <1416657952874-5759495.post@n5.nabble.com>
References: <1416657952874-5759495.post@n5.nabble.com>
Date: Sat, 22 Nov 2014 22:34:40 +0100
Message-ID: 
 <CAGO7Ob3iPDCDViJ+BQk6xrs5icV2koy216hZv2ZyY1tDg5SPSw@mail.gmail.com>
Subject: Re: how to execte jdbc IN clause statement
From: David Karlsen <davidkarlsen@gmail.com>
To: users@camel.apache.org
Content-Type: multipart/alternative; boundary=001a11c2a3a63ccc0f0508795430
X-Virus-Checked: Checked by ClamAV on apache.org

--001a11c2a3a63ccc0f0508795430
Content-Type: text/plain; charset=UTF-8

Would a collection of integers work?
22. Nov. 2014 13:06 skrev "chaituu" <yarlagadda54@gmail.com>:

> 22 04:02:32,011  #0 - timer://timer1 TimerConsumer             WARN
> warn                                MarkerIgnoringBase.java
> :136    Error processing exchange. Exchange[Message: UPDATE TEST SET
> FLAG='Y' WHERE ID IN(:?ids)]. Caused by: [java.sql.SQLSyntaxErrorException
> -
> ORA-01722: invalid number
> ]
> java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
>
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
>         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
>         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
>
> <route>
> <from uri="direct:sendUpdate"/>
>       <setHeader headerName="ids">
>         <simple>127,128</simple>
>       </setHeader>
>
>        <setBody>
>         <constant>
>           UPDATE TEST SET FLAG='Y' WHERE ID IN(:?ids)
>         </constant>
>       </setBody>
>       <to uri="jdbc:dataSource?useHeadersAsParameters=true"/>
>        <log message="update done on:${headers.ids}- "/>
>     </route>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/how-to-execte-jdbc-IN-clause-statement-tp5759495.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>

--001a11c2a3a63ccc0f0508795430--