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)
