You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by bu...@apache.org on 2014/06/05 09:17:56 UTC
svn commit: r911405 - in /websites/production/camel/content:
cache/main.pageCache how-do-i-edit-the-website.html sql-component.html
Author: buildbot
Date: Thu Jun 5 07:17:56 2014
New Revision: 911405
Log:
Production update by buildbot for camel
Modified:
websites/production/camel/content/cache/main.pageCache
websites/production/camel/content/how-do-i-edit-the-website.html
websites/production/camel/content/sql-component.html
Modified: websites/production/camel/content/cache/main.pageCache
==============================================================================
Binary files - no diff available.
Modified: websites/production/camel/content/how-do-i-edit-the-website.html
==============================================================================
--- websites/production/camel/content/how-do-i-edit-the-website.html (original)
+++ websites/production/camel/content/how-do-i-edit-the-website.html Thu Jun 5 07:17:56 2014
@@ -75,42 +75,16 @@
<tbody>
<tr>
<td valign="top" width="100%">
-<div class="wiki-content maincontent"><h2 id="HowdoIeditthewebsite-HowdoIeditthewebsite?">How do I edit the website?</h2>
-
-<p>The website is all contained on a Wiki so that you can <a shape="rect" href="contributing.html">contribute</a> providing you are happy to license all your contributions under the <a shape="rect" class="external-link" href="http://www.apache.org/licenses/LICENSE-2.0">Apache Software License version 2.0</a></p>
-
-<h3 id="HowdoIeditthewebsite-YoumusthavesignedanICLAtobeabletoeditthewikipages">You must have signed an ICLA to be able to edit the wiki pages</h3>
-<ul><li>Download and print the Apache Contributor License Agreement from <a shape="rect" class="external-link" href="http://www.apache.org/dev/new-committers-guide.html">here</a>. You need to sign it and fax it to Apache. In the past I've found its often faster to also post it via snail mail</li><li>wait for your name to appear on the <a shape="rect" class="external-link" href="http://people.apache.org/committer-index.html">list of received CLAs</a> see the <em>unlisted CLAs</em> section.</li><li>send an email to the <a shape="rect" href="mailing-lists.html">Camel dev forum</a> about that your ICLA have been received at Apache.</li></ul>
-
-
-<h3 id="HowdoIeditthewebsite-Howtoedit">How to edit</h3>
-
-<p>To edit a page, just hit the <strong>edit</strong> link right at the bottom of any page. To be able to edit you need to register with confluence. </p>
-
- <div class="aui-message hint shadowed information-macro">
+<div class="wiki-content maincontent"><h2 id="HowdoIeditthewebsite-HowdoIeditthewebsite?">How do I edit the website?</h2><p>The website is all contained on a Wiki so that you can <a shape="rect" href="contributing.html">contribute</a> providing you are happy to license all your contributions under the <a shape="rect" class="external-link" href="http://www.apache.org/licenses/LICENSE-2.0">Apache Software License version 2.0</a></p><h3 id="HowdoIeditthewebsite-YoumusthavesignedanICLAtobeabletoeditthewikipages">You must have signed an ICLA to be able to edit the wiki pages</h3><ul><li>Download and print the Apache Contributor License Agreement from <a shape="rect" class="external-link" href="http://www.apache.org/dev/new-committers-guide.html">here</a>. You need to sign it and fax it to Apache. In the past I've found its often faster to also post it via snail mail</li><li>wait for your name to appear on the <a shape="rect" class="external-link" href="http://people.apache.org/committer-
index.html">list of received CLAs</a> see the <em>unlisted CLAs</em> section.</li><li>send an email to the <a shape="rect" href="mailing-lists.html">Camel dev forum</a> about that your ICLA have been received at Apache, and include your <strong>wiki</strong> <strong>username</strong> in the email.</li><li>A Camel PMC member will then verify that ASF have received the ICLA and assign edit rights to your username, using <a shape="rect" href="https://cwiki.apache.org/confluence/spaces/spacepermissions.action?key=CAMEL">this page</a>.</li></ul><h3 id="HowdoIeditthewebsite-Howtoedit">How to edit</h3><p>To edit a page, just hit the <strong>edit</strong> link right at the bottom of any page. To be able to edit you need to register with confluence.</p> <div class="aui-message hint shadowed information-macro">
<p class="title">Spam Prevention</p>
<span class="aui-icon icon-hint">Icon</span>
<div class="message-content">
-
-<p>We have been attacked by spammers so we are running a spam-avoiding scheme. So you have to ask to be added to the editing group of Confluence. This is quick and easy to do.</p>
-
-<p>First click edit on a page to get to the confluence site of <a shape="rect" class="external-link" href="http://cwiki.apache.org/confluence/display/CAMEL/Index">http://cwiki.apache.org/confluence/display/CAMEL/Index</a> then register.</p>
-
-<p>Then send an mail to the <a shape="rect" class="external-link" href="http://www.nabble.com/Camel-Development-f36429.html" rel="nofollow">developer forum</a> giving details of your confluence and/or JIRA username and we can grant you the necessary editing karma.</p>
+ <p>We have been attacked by spammers so we are running a spam-avoiding scheme. So you have to ask to be added to the editing group of Confluence. This is quick and easy to do.</p><p>First click edit on a page to get to the confluence site of <a shape="rect" class="external-link" href="http://cwiki.apache.org/confluence/display/CAMEL/Index">http://cwiki.apache.org/confluence/display/CAMEL/Index</a> then register.</p><p>Then send an mail to the <a shape="rect" class="external-link" href="http://www.nabble.com/Camel-Development-f36429.html" rel="nofollow">developer forum</a> giving details of your confluence and/or JIRA username and we can grant you the necessary editing karma.</p>
</div>
</div>
+<p>Note that after you've changed the wiki it is immediately rendered on the <a shape="rect" class="external-link" href="http://cwiki.apache.org/CAMEL/">http://cwiki.apache.org/CAMEL/</a> site so you can test it out; then up to an hour or two later it is updated on the Apache site.</p><h3 id="HowdoIeditthewebsite-Howthesiteworks">How the site works</h3><p>There are a few special pages; for example the <a shape="rect" href="navigation.html">Navigation</a> page is the right hand navigation bar and the <a shape="rect" href="quicklinks.html">QuickLinks</a> is the top right navigation bar.</p><p>Other useful <a shape="rect" href="site.html">links</a> are</p><p>This page contains the main navigation links to the parts which make up the Site layout.
-
-<p>Note that after you've changed the wiki it is immediately rendered on the <a shape="rect" class="external-link" href="http://cwiki.apache.org/CAMEL/">http://cwiki.apache.org/CAMEL/</a> site so you can test it out; then up to an hour or two later it is updated on the Apache site.</p>
-
-<h3 id="HowdoIeditthewebsite-Howthesiteworks">How the site works</h3>
-<p>There are a few special pages; for example the <a shape="rect" href="navigation.html">Navigation</a> page is the right hand navigation bar and the <a shape="rect" href="quicklinks.html">QuickLinks</a> is the top right navigation bar.</p>
-
-<p>Other useful <a shape="rect" href="site.html">links</a> are</p>
-
-This page contains the main navigation links to the parts which make up the Site layout.
-
-<ul class="childpages-macro"><li><a shape="rect" href="banner.html">Banner</a></li><li><a shape="rect" href="book.html">Book</a></li><li><a shape="rect" href="book-in-one-page.html">Book In One Page</a></li><li><a shape="rect" href="includes.html">Includes</a></li><li><a shape="rect" href="navigation.html">Navigation</a></li><li><a shape="rect" href="quicklinks.html">QuickLinks</a></li><li><a shape="rect" href="scratch-page.html">Scratch Page</a></li><li><a shape="rect" href="siteindex.html">SiteIndex</a></li><li><a shape="rect" href="sitemap.html">SiteMap</a></li><li><a shape="rect" href="site-update-ideas.html">Site Update Ideas</a></li></ul> </div>
+</p><ul class="childpages-macro"><li><a shape="rect" href="banner.html">Banner</a></li><li><a shape="rect" href="book.html">Book</a></li><li><a shape="rect" href="book-in-one-page.html">Book In One Page</a></li><li><a shape="rect" href="includes.html">Includes</a></li><li><a shape="rect" href="navigation.html">Navigation</a></li><li><a shape="rect" href="quicklinks.html">QuickLinks</a></li><li><a shape="rect" href="scratch-page.html">Scratch Page</a></li><li><a shape="rect" href="siteindex.html">SiteIndex</a></li><li><a shape="rect" href="sitemap.html">SiteMap</a></li><li><a shape="rect" href="site-update-ideas.html">Site Update Ideas</a></li></ul> </div>
</td>
<td valign="top">
<div class="navigation">
Modified: websites/production/camel/content/sql-component.html
==============================================================================
--- websites/production/camel/content/sql-component.html (original)
+++ websites/production/camel/content/sql-component.html Thu Jun 5 07:17:56 2014
@@ -113,7 +113,9 @@
</div></div><p>From Camel 2.11 onwards you can use named parameters by using <code>#:name</code> style as shown:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<script class="theme: Default; brush: java; gutter: false" type="syntaxhighlighter"><![CDATA[sql:select * from table where id=:#myId order by name[?options]
]]></script>
-</div></div><p>When using named parameters, Camel will lookup the names from, in the given precedence:<br clear="none"> 1. from message body if its a <code>java.util.Map</code><br clear="none"> 2. from message headers</p><p>If a named parameter cannot be resolved, then an exception is thrown.</p><p>Notice that the standard <code>?</code> symbol that denotes the parameters to an SQL query is substituted with the <code>#</code> symbol, because the <code>?</code> symbol is used to specify options for the endpoint. The <code>?</code> symbol replacement can be configured on endpoint basis.</p><p>You can append query options to the URI in the following format, <code>?option=value&option=value&...</code></p><h3 id="SQLComponent-Options">Options</h3><div class="confluenceTableSmall">
+</div></div><p>When using named parameters, Camel will lookup the names from, in the given precedence:<br clear="none"> 1. from message body if its a <code>java.util.Map</code><br clear="none"> 2. from message headers</p><p>If a named parameter cannot be resolved, then an exception is thrown.</p><p>From Camel 2.14 onward you can use Simple expressions as parameters as shown:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
+<script class="theme: Default; brush: java; gutter: false" type="syntaxhighlighter"><![CDATA[sql:select * from table where id=:#${property.myId} order by name[?options]]]></script>
+</div></div><p>Notice that the standard <code>?</code> symbol that denotes the parameters to an SQL query is substituted with the <code>#</code> symbol, because the <code>?</code> symbol is used to specify options for the endpoint. The <code>?</code> symbol replacement can be configured on endpoint basis.</p><p>You can append query options to the URI in the following format, <code>?option=value&option=value&...</code></p><h3 id="SQLComponent-Options">Options</h3><div class="confluenceTableSmall">
<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1" class="confluenceTh"><p> Option </p></th><th colspan="1" rowspan="1" class="confluenceTh"><p> Type </p></th><th colspan="1" rowspan="1" class="confluenceTh"><p> Default </p></th><th colspan="1" rowspan="1" class="confluenceTh"><p> Description </p></th></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>batch</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>false</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.7.5, 2.8.4 and 2.9:</strong> Execute SQL batch update statements. See notes below on how the treatment of the inbound message body changes if this is set to <code>true</code>. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>dataSourceRef</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>String</co
de> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>null</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Deprecated and will be removed in Camel 3.0:</strong> Reference to a <code>DataSource</code> to look up in the registry. Use <code>dataSource=#theName</code> instead. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>dataSource</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>String</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>null</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> Reference to a <code>DataSource</code> to look up in the registry. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>placeholder</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>String</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>#</code> </p></
td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.4:</strong> Specifies a character that will be replaced to <code>?</code> in SQL query. Notice, that it is simple <code>String.replaceAll()</code> operation and no SQL parsing is involved (quoted strings will also change). This replacement is <strong>only</strong> happening if the endpoint is created using the <code>SqlComponent</code>. If you manually create the endpoint, then use the expected <code>?</code> sign instead. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>template.<xxx></code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>null</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> Sets additional options on the Spring <code>JdbcTemplate</code> that is used behind the scenes to execute the queries. For instance, <code>template.maxRows=10</code>. For detailed docu
mentation, see the <a shape="rect" class="external-link" href="http://static.springframework.org/spring/docs/2.5.x/api/org/springframework/jdbc/core/JdbcTemplate.html" rel="nofollow">JdbcTemplate javadoc</a> documentation. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>allowNamedParameters</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>true</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> Whether to allow using named parameters in the queries. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>processingStrategy</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</str
ong> Allows to plugin to use a custom <code>org.apache.camel.component.sql.SqlProcessingStrategy</code> to execute queries when the consumer has processed the rows/batch. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>prepareStatementStrategy</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> Allows to plugin to use a custom <code>org.apache.camel.component.sql.SqlPrepareStatementStrategy</code> to control preparation of the query and prepared statement. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.delay</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>long</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>500</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong
>Camel 2.11:</strong> <strong>SQL consumer only:</strong> Delay in milliseconds between each poll. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.initialDelay</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>long</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>1000</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> Milliseconds before polling starts. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.useFixedDelay</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>false</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> Set to <code>true</code> to use fixed delay between polls, otherwise fi
xed rate is used. See <a shape="rect" class="external-link" href="http://java.sun.com/j2se/1.5.0/docs/api/java/util/concurrent/ScheduledExecutorService.html" rel="nofollow">ScheduledExecutorService</a> in JDK for details. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>maxMessagesPerPoll</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>int</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>0</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> An integer value to define the maximum number of messages to gather per poll. By default, no maximum is set. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.useIterator</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>true</code> </p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> If <code>true</code> each row returned when polling will be processed individually. If <code>false</code> the entire <code>java.util.List</code> of data is set as the IN body. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.routeEmptyResultSet</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>false</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> Whether to route a single empty <a shape="rect" href="exchange.html" title="Exchange">Exchange</a> if there was no data to poll. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.onConsume</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>St
ring</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>null</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> After processing each row then this query can be executed, if the <a shape="rect" href="exchange.html" title="Exchange">Exchange</a> was processed successfully, for example to mark the row as processed. The query can have parameter. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.onConsumeFailed</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>String</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>null</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> After processing each row then this query can be executed, if the <a shape="rect" href="exchange.html" title="Exchange">Exchange</a> failed, for ex
ample to mark the row as failed. The query can have parameter. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.onConsumeBatchComplete</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>String</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>null</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> After processing the entire batch, this query can be executed to bulk update rows etc. The query cannot have parameters. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.expectedUpdateCount</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>int</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>-1</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> If using <
code>consumer.onConsume</code> then this option can be used to set an expected number of rows being updated. Typically you may set this to <code>1</code> to expect one row to be updated. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>consumer.breakBatchOnConsumeFail</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>false</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL consumer only:</strong> If using <code>consumer.onConsume</code> and it fails, then this option controls whether to break out of the batch or continue processing the next row from the batch. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>alwaysPopulateStatement</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>boolean</code> </p></td><td colspan="1" rowspan="1" class="
confluenceTd"><p> <code>false</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11:</strong> <strong>SQL producer only:</strong> If enabled then the <code>populateStatement</code> method from <code>org.apache.camel.component.sql.SqlPrepareStatementStrategy</code> is always invoked, also if there is no expected parameters to be prepared. When this is <code>false</code> then the <code>populateStatement</code> is only invoked if there is 1 or more expected parameters to be set; for example this avoids reading the message body/headers for SQL queries with no parameters. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>separator</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>char</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>,</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.11.1:</strong> The separator to use when parameter values is
taken from message body (if the body is a String type), to be inserted at # placeholders. Notice if you use named parameters, then a <code>Map</code> type is used instead. </p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>outputType</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>String</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <code>SelectList</code> </p></td><td colspan="1" rowspan="1" class="confluenceTd"><p> <strong>Camel 2.12.0:</strong> Make the output of consumer or producer to <code>SelectList</code> as List of Map, or <code>SelectOne</code> as single Java object in the following way:<br clear="none">
a) If the query has only single column, then that JDBC Column object is returned. (such as <code>SELECT COUNT( * ) FROM PROJECT</code> will return a Long object.<br clear="none">
b) If the query has more than one column, then it will return a Map of that result.<br clear="none">
@@ -176,6 +178,11 @@ assertEquals("Linux", row.get(
<script class="theme: Default; brush: java; gutter: false" type="syntaxhighlighter"><![CDATA[ from("direct:projects")
.to("sql:select * from projects where license = :#lic and id > :#min order by id")
]]></script>
+</div></div><h4 id="SQLComponent-Usingexpressionparameters">Using expression parameters</h4><p><strong>Available as of Camel 2.14</strong></p><p>In the given route below, we want to get all the project from the database. It uses the body of the exchange for defining the license and uses the value of a property as the second parameter.</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
+<script class="theme: Default; brush: java; gutter: false" type="syntaxhighlighter"><![CDATA[from("direct:projects")
+ .setBody(constant("ASF"))
+ .setProperty("min", constant(123))
+ .to("sql:select * from projects where license = :#${body} and id > :#${property.min} order by id")]]></script>
</div></div><h3 id="SQLComponent-UsingtheJDBCbasedidempotentrepository">Using the JDBC based idempotent repository</h3><p><strong>Available as of Camel 2.7</strong>: In this section we will use the JDBC based idempotent repository.</p> <div class="aui-message success shadowed information-macro">
<p class="title">Abstract class</p>
<span class="aui-icon icon-success">Icon</span>