Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id CB2862009C6 for ; Tue, 31 May 2016 15:42:59 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id C9926160A44; Tue, 31 May 2016 13:42:59 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 1D79A1609AD for ; Tue, 31 May 2016 15:42:58 +0200 (CEST) Received: (qmail 40388 invoked by uid 500); 31 May 2016 13:42:58 -0000 Mailing-List: contact users-help@camel.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@camel.apache.org Delivered-To: mailing list users@camel.apache.org Received: (qmail 40377 invoked by uid 99); 31 May 2016 13:42:57 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2016 13:42:57 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 830D51A0916 for ; Tue, 31 May 2016 13:42:57 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.486 X-Spam-Level: *** X-Spam-Status: No, score=3.486 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_SOFTFAIL=0.972, URI_HEX=1.313] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Dv6GFpcU8pRG for ; Tue, 31 May 2016 13:42:55 +0000 (UTC) Received: from mbob.nabble.com (mbob.nabble.com [162.253.133.15]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 56E665F24F for ; Tue, 31 May 2016 13:42:55 +0000 (UTC) Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id 424AD290735A for ; Tue, 31 May 2016 06:24:55 -0700 (PDT) Date: Tue, 31 May 2016 06:42:54 -0700 (MST) From: imranrazakhan To: users@camel.apache.org Message-ID: <1464702174601-5783303.post@n5.nabble.com> In-Reply-To: <1464698607712-5783298.post@n5.nabble.com> References: <1464638951342-5783264.post@n5.nabble.com> <1464675484026-5783271.post@n5.nabble.com> <1464679601832-5783279.post@n5.nabble.com> <1464693832036-5783293.post@n5.nabble.com> <1464695498176-5783294.post@n5.nabble.com> <1464698607712-5783298.post@n5.nabble.com> Subject: Re: camel-sql - SQL IN Query issue (2.17.1) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit archived-at: Tue, 31 May 2016 13:43:00 -0000 Following main class Main main = new Main(); main.addRouteBuilder( new GetAccountStatusBulk() ); main.getOrCreateCamelContext().getComponent("sql", SqlComponent.class).setDataSource(setupDataSource()); main.run(args); Following change in roue .to("sql:select status from subscriber where mobilenumber in (:#in:mobilenumbers)") Error : Exception in thread "main" org.apache.camel.FailedToCreateRouteException: Failed to create route route1 at: Caused by: java.lang.IllegalArgumentException: DataSource must be configured -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783303.html Sent from the Camel - Users mailing list archive at Nabble.com.