Return-Path: 
 <users-return-49828-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 D353311CDA
	for <apmail-camel-users-archive@www.apache.org>;
 Wed,  9 Jul 2014 12:01:28 +0000 (UTC)
Received: (qmail 50852 invoked by uid 500); 9 Jul 2014 12:01:28 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 50822 invoked by uid 500); 9 Jul 2014 12:01:28 -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 50811 invoked by uid 99); 9 Jul 2014 12:01:27 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jul 2014 12:01:27 +0000
X-ASF-Spam-Status: No, hits=2.3 required=5.0
	tests=SPF_SOFTFAIL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: softfail (athena.apache.org: transitioning domain of
 akoufoudakis@gmail.com does not designate 216.139.236.26 as permitted sender)
Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jul 2014 12:01:23 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <akoufoudakis@gmail.com>)
	id 1X4qYZ-00089W-3H
	for users@camel.apache.org; Wed, 09 Jul 2014 05:01:03 -0700
Date: Wed, 9 Jul 2014 05:01:03 -0700 (PDT)
From: akoufoudakis <akoufoudakis@gmail.com>
To: users@camel.apache.org
Message-ID: <1404907263093-5753585.post@n5.nabble.com>
In-Reply-To: <1404906839276-5753583.post@n5.nabble.com>
References: <1404899777117-5753574.post@n5.nabble.com>
 <1404900569510-5753576.post@n5.nabble.com>
 <1404906839276-5753583.post@n5.nabble.com>
Subject: Re: Configuring database with jdbc
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

In your route:

 .to("jdbc:dataSource?useHeadersAsParameters=true");

the "dataSource" should be a data source (e. g., apache dbcp).
It should be configured via Spring as a bean.

<bean id = "dataSource" ...>
.....
</bean>.
To configure it properly, please check the link provided by Charles in his
reply to you or take fradj reply as an example.

If you have it already configured, check if there is a database connectivity
problem or check, whether your select statement is correct.



--
View this message in context: http://camel.465427.n5.nabble.com/Configuring-database-with-jdbc-tp5753574p5753585.html
Sent from the Camel - Users mailing list archive at Nabble.com.