Return-Path: 
 <users-return-59369-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 BC5CD18665
	for <apmail-camel-users-archive@www.apache.org>;
 Fri, 19 Feb 2016 22:38:28 +0000 (UTC)
Received: (qmail 56901 invoked by uid 500); 19 Feb 2016 22:38:28 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 56846 invoked by uid 500); 19 Feb 2016 22:38: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 56835 invoked by uid 99); 19 Feb 2016 22:38:27 -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; Fri, 19 Feb 2016 22:38:27 +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 8B5F11A1085
	for <users@camel.apache.org>; Fri, 19 Feb 2016 22:38:27 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 1.313
X-Spam-Level: *
X-Spam-Status: No, score=1.313 tagged_above=-999 required=6.31
	tests=[RCVD_IN_DNSWL_NONE=-0.0001, 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 vM6KQr6Q1sp6 for <users@camel.apache.org>;
	Fri, 19 Feb 2016 22:38:24 +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 3161B5FAD4
	for <users@camel.apache.org>; Fri, 19 Feb 2016 22:38:24 +0000 (UTC)
Received: from msam.nabble.com (unknown [162.253.133.85])
	by mbob.nabble.com (Postfix) with ESMTP id 1D29021206C7
	for <users@camel.apache.org>; Fri, 19 Feb 2016 14:31:29 -0800 (PST)
Date: Fri, 19 Feb 2016 15:38:23 -0700 (MST)
From: Launcelot <drajagop@standard.com>
To: users@camel.apache.org
Message-ID: <1455921503813-5777954.post@n5.nabble.com>
Subject: Usage of properties in datasource definition - Please help
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have a property file defined as follows
<camelContext trace="true"
		id="context-c2d439e2-f530-4c6d-8480-86f290cbf297"
xmlns="http://camel.apache.org/schema/spring">
		
		<propertyPlaceholder id="properties" location="db.properties"
propertyPrefix="${" propertySuffix="}"/>
		<route>
db.properties has a property in it which contains
db.pass=valuesnipped


I have a datasource definition as under
<bean id="myDataSource" class="org.apache.tomcat.jdbc.pool.DataSource">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"
/>
		<property name="url" value="jdbc:oracle:thin:@seq1:1521:sfgd" />
		<property name="username" value="valuesnipped" />
		<property name="password" value="${db.pass}" />
		<property name="maxWait" value="1000" />
		<property name="validationQueryTimeout" value="3" />
		<property name="initialSize" value="8" />
		<property name="maxIdle" value="32" />
		<property name="removeAbandoned" value="true" />
		<property name="removeAbandonedTimeout" value="60" />
		<property name="logValidationErrors" value="true" />
		<property name="testWhileIdle" value="true" />
		<property name="testOnBorrow" value="true" />
		<property name="testOnConnect" value="true" />
		<property name="testOnReturn" value="false" />
		<property name="validationQuery" value="/* Oracle Health Check */ SELECT 1
FROM DUAL" />
		
	</bean>                

I get exceptions connecting to the database indicating invalid
user/password. I have tried using {{db.pass}} which also does not work,
probably because it is literally assigning the value as {{db.pass}}. If i
just use the actual password above it works fine. The aim is ultimately to
use jasypt but that is a problem for another day.

Any help indicating how I can accomplish setting the password from a
property file is appreciated.

Thanks



--
View this message in context: http://camel.465427.n5.nabble.com/Usage-of-properties-in-datasource-definition-Please-help-tp5777954.html
Sent from the Camel - Users mailing list archive at Nabble.com.