Return-Path: 
 <commits-return-25383-apmail-camel-commits-archive=camel.apache.org@camel.apache.org>
X-Original-To: apmail-camel-commits-archive@www.apache.org
Delivered-To: apmail-camel-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id CB554E333
	for <apmail-camel-commits-archive@www.apache.org>;
 Fri, 18 Jan 2013 12:08:37 +0000 (UTC)
Received: (qmail 39811 invoked by uid 500); 18 Jan 2013 11:59:37 -0000
Delivered-To: apmail-camel-commits-archive@camel.apache.org
Received: (qmail 39538 invoked by uid 500); 18 Jan 2013 11:59:22 -0000
Mailing-List: contact commits-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:commits-help@camel.apache.org>
List-Unsubscribe: <mailto:commits-unsubscribe@camel.apache.org>
List-Post: <mailto:commits@camel.apache.org>
List-Id: <commits.camel.apache.org>
Reply-To: dev@camel.apache.org
Delivered-To: mailing list commits@camel.apache.org
Received: (qmail 39489 invoked by uid 99); 18 Jan 2013 11:59:20 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Jan 2013 11:59:20 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Jan 2013 11:59:19 +0000
Received: from eris.apache.org (localhost [127.0.0.1])
	by eris.apache.org (Postfix) with ESMTP id 25FA023889DA;
	Fri, 18 Jan 2013 11:59:00 +0000 (UTC)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1435103 - in /camel/trunk/examples/camel-example-sql:
 pom.xml
 src/main/resources/sql.properties
Date: Fri, 18 Jan 2013 11:59:00 -0000
To: commits@camel.apache.org
From: davsclaus@apache.org
X-Mailer: svnmailer-1.0.8-patched
Message-Id: <20130118115900.25FA023889DA@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

Author: davsclaus
Date: Fri Jan 18 11:58:59 2013
New Revision: 1435103

URL: http://svn.apache.org/viewvc?rev=1435103&view=rev
Log:
New example for using SQL component

Modified:
    camel/trunk/examples/camel-example-sql/pom.xml
    camel/trunk/examples/camel-example-sql/src/main/resources/sql.properties

Modified: camel/trunk/examples/camel-example-sql/pom.xml
URL: http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-sql/pom.xml?rev=1435103&r1=1435102&r2=1435103&view=diff
==============================================================================
--- camel/trunk/examples/camel-example-sql/pom.xml (original)
+++ camel/trunk/examples/camel-example-sql/pom.xml Fri Jan 18 11:58:59 2013
@@ -53,7 +53,6 @@
     <dependency>
       <groupId>org.apache.derby</groupId>
       <artifactId>derby</artifactId>
-      <scope>test</scope>
     </dependency>
     <dependency>
       <groupId>commons-dbcp</groupId>

Modified: camel/trunk/examples/camel-example-sql/src/main/resources/sql.properties
URL: http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-sql/src/main/resources/sql.properties?rev=1435103&r1=1435102&r2=1435103&view=diff
==============================================================================
--- camel/trunk/examples/camel-example-sql/src/main/resources/sql.properties (original)
+++ camel/trunk/examples/camel-example-sql/src/main/resources/sql.properties Fri Jan 18 11:58:59 2013
@@ -16,6 +16,7 @@
 ## ------------------------------------------------------------------------
 
 ## START SNIPPET: e1
+## notice we use named parameters in the queries, eg :#name. A named query parameter must start with :#
 ## sql that insert new orders
 sql.insertOrder=insert into orders (id, item, amount, description, processed) values (:#id, :#item, :#amount, :#description, false)