Author: buildbot
Date: Thu Jan 17 13:24:45 2013
New Revision: 846998
Log:
Production update by buildbot for camel
Modified:
websites/production/camel/content/batch-consumer.html
websites/production/camel/content/book-component-appendix.html
websites/production/camel/content/book-in-one-page.html
websites/production/camel/content/cache/main.pageCache
websites/production/camel/content/sql-component.html
Modified: websites/production/camel/content/batch-consumer.html
==============================================================================
--- websites/production/camel/content/batch-consumer.html (original)
+++ websites/production/camel/content/batch-consumer.html Thu Jan 17 13:24:45
2013
@@ -81,7 +81,7 @@
<p>Batch Consumer is basically a <a shape="rect" href="polling-consumer.html"
title="Polling Consumer">Polling Consumer</a> that is capable of polling
multiple <a shape="rect" href="exchange.html" title="Exchange">Exchange</a>s in
a pool. What we have done in Camel 2.0 is to standardize this into a
<tt>org.apache.camel.BatchConsumer</tt> interface that a consumer can implement
to indicate it support batching as well.</p>
<p>The following components supports <a shape="rect"
href="batch-consumer.html" title="Batch Consumer">Batch Consumer</a> by its
consumer:</p>
-<ul class="alternate" type="square"><li><a shape="rect" href="atom.html"
title="Atom">Atom</a></li><li><a shape="rect" href="file2.html"
title="File2">File</a></li><li><a shape="rect" href="ftp2.html"
title="FTP2">FTP</a></li><li><a shape="rect" href="hbase.html"
title="hbase">hbase</a></li><li><a shape="rect" href="ibatis.html"
title="iBATIS">iBATIS</a></li><li><a shape="rect" href="jpa.html"
title="JPA">JPA</a></li><li><a shape="rect" href="jclouds.html"
title="jclouds">jclouds</a></li><li><a shape="rect" href="mail.html"
title="Mail">Mail</a></li><li><a shape="rect" href="mybatis.html"
title="MyBatis">MyBatis</a></li><li><a shape="rect" href="snmp.html"
title="SNMP">SNMP</a></li><li><a shape="rect" href="aws-sqs.html"
title="AWS-SQS">SQS</a></li><li><a shape="rect" href="aws-s3.html"
title="AWS-S3">S3</a></li></ul>
+<ul class="alternate" type="square"><li><a shape="rect" href="atom.html"
title="Atom">Atom</a></li><li><a shape="rect" href="file2.html"
title="File2">File</a></li><li><a shape="rect" href="ftp2.html"
title="FTP2">FTP</a></li><li><a shape="rect" href="hbase.html"
title="hbase">hbase</a></li><li><a shape="rect" href="ibatis.html"
title="iBATIS">iBATIS</a></li><li><a shape="rect" href="jpa.html"
title="JPA">JPA</a></li><li><a shape="rect" href="jclouds.html"
title="jclouds">jclouds</a></li><li><a shape="rect" href="mail.html"
title="Mail">Mail</a></li><li><a shape="rect" href="mybatis.html"
title="MyBatis">MyBatis</a></li><li><a shape="rect" href="snmp.html"
title="SNMP">SNMP</a></li><li><a shape="rect" href="sql-component.html"
title="SQL Component">SQL</a></li><li><a shape="rect" href="aws-sqs.html"
title="AWS-SQS">SQS</a></li><li><a shape="rect" href="aws-s3.html"
title="AWS-S3">S3</a></li></ul>
<h3><a shape="rect" name="BatchConsumer-ConsumerOptions"></a>Consumer
Options</h3>
Modified: websites/production/camel/content/book-component-appendix.html
==============================================================================
--- websites/production/camel/content/book-component-appendix.html (original)
+++ websites/production/camel/content/book-component-appendix.html Thu Jan 17
13:24:45 2013
@@ -16299,7 +16299,7 @@ sql:select * from table where id=# order
<h3><a shape="rect" name="BookComponentAppendix-Options"></a>Options</h3>
<div class="confluenceTableSmall"><div class="table-wrap">
-<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1"
class="confluenceTh"> Option </th><th colspan="1" rowspan="1"
class="confluenceTh"> Type </th><th colspan="1" rowspan="1"
class="confluenceTh"> Default </th><th colspan="1" rowspan="1"
class="confluenceTh"> Description </th></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>batch</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.7.5, 2.8.4 and 2.9:</b> Execute SQL batch
update statements. See notes below on how the treatment of the inbound message
body changes if this is set to <tt>true</tt>. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>dataSourceRef</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>String</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>null</tt> </td><td colspan="1
" rowspan="1" class="confluenceTd"> Reference to a <tt>DataSource</tt> to look
up in the registry. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>placeholder</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>String</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>#</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.4:</b> Specifies a character that will be
replaced to <tt>?</tt> in SQL query. Notice, that it is simple
<tt>String.replaceAll()</tt> operation and no SQL parsing is involved (quoted
strings will also change) </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>template.<xxx></tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>null</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> Sets additional options on the Spring
<tt>JdbcTemplate</tt> that is used behind the scenes to execute the queries.
For instance, <tt>template.maxRows=10</tt>. For detailed documentation, 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. </td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>consumer.delay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>500</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Delay in milliseconds between each poll. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>consumer.initialDelay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>1000</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> Millis
econds before polling starts. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useFixedDelay</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Set to <tt>true</tt> to use fixed delay between polls, otherwise fixed 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.
</td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>maxMessagesPerPoll</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>0</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> An int
eger value to define the maximum number of messages to gather per poll. By
default, no maximum is set. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useIterator</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>true</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
If <tt>true</tt> each row returned when polling will be processed individually.
If <tt>false</tt> the entire <tt>java.util.List</tt> of data is set as the IN
body. </td></tr></tbody></table>
+<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1"
class="confluenceTh"> Option </th><th colspan="1" rowspan="1"
class="confluenceTh"> Type </th><th colspan="1" rowspan="1"
class="confluenceTh"> Default </th><th colspan="1" rowspan="1"
class="confluenceTh"> Description </th></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>batch</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.7.5, 2.8.4 and 2.9:</b> Execute SQL batch
update statements. See notes below on how the treatment of the inbound message
body changes if this is set to <tt>true</tt>. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>dataSourceRef</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>String</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>null</tt> </td><td colspan="1
" rowspan="1" class="confluenceTd"> Reference to a <tt>DataSource</tt> to look
up in the registry. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>placeholder</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>String</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>#</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.4:</b> Specifies a character that will be
replaced to <tt>?</tt> in SQL query. Notice, that it is simple
<tt>String.replaceAll()</tt> operation and no SQL parsing is involved (quoted
strings will also change) </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>template.<xxx></tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>null</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> Sets additional options on the Spring
<tt>JdbcTemplate</tt> that is used behind the scenes to execute the queries.
For instance, <tt>template.maxRows=10</tt>. For detailed documentation, 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. </td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>consumer.delay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>500</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Delay in milliseconds between each poll. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>consumer.initialDelay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>1000</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> Millis
econds before polling starts. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useFixedDelay</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Set to <tt>true</tt> to use fixed delay between polls, otherwise fixed 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.
</td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>maxMessagesPerPoll</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>0</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> An int
eger value to define the maximum number of messages to gather per poll. By
default, no maximum is set. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useIterator</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>true</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
If <tt>true</tt> each row returned when polling will be processed individually.
If <tt>false</tt> the entire <tt>java.util.List</tt> of data is set as the IN
body. </td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>consumer.routeEmptyResultSet</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> Whether to
route a single empty <a shape="r
ect" href="exchange.html" title="Exchange">Exchange</a> if there was no data
to poll. </td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>consumer.expectedUpdateCount</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>-1</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> If using
<tt>consumer.onConsume</tt> then this option can be used to set an expected
number of rows being updated. Typically you may set this to <tt>1</tt> to
expect one row to be updated. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.breakBatchOnConsumeFail</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> If using <tt>consumer.onCons
ume</tt> and it fails, then this option controls whether to break out of the
batch or continue processing the next row from the batch.
</td></tr></tbody></table>
</div>
</div>
Modified: websites/production/camel/content/book-in-one-page.html
==============================================================================
--- websites/production/camel/content/book-in-one-page.html (original)
+++ websites/production/camel/content/book-in-one-page.html Thu Jan 17 13:24:45
2013
@@ -36533,7 +36533,7 @@ sql:select * from table where id=# order
<h3><a shape="rect" name="BookInOnePage-Options"></a>Options</h3>
<div class="confluenceTableSmall"><div class="table-wrap">
-<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1"
class="confluenceTh"> Option </th><th colspan="1" rowspan="1"
class="confluenceTh"> Type </th><th colspan="1" rowspan="1"
class="confluenceTh"> Default </th><th colspan="1" rowspan="1"
class="confluenceTh"> Description </th></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>batch</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.7.5, 2.8.4 and 2.9:</b> Execute SQL batch
update statements. See notes below on how the treatment of the inbound message
body changes if this is set to <tt>true</tt>. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>dataSourceRef</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>String</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>null</tt> </td><td colspan="1
" rowspan="1" class="confluenceTd"> Reference to a <tt>DataSource</tt> to look
up in the registry. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>placeholder</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>String</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>#</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.4:</b> Specifies a character that will be
replaced to <tt>?</tt> in SQL query. Notice, that it is simple
<tt>String.replaceAll()</tt> operation and no SQL parsing is involved (quoted
strings will also change) </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>template.<xxx></tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>null</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> Sets additional options on the Spring
<tt>JdbcTemplate</tt> that is used behind the scenes to execute the queries.
For instance, <tt>template.maxRows=10</tt>. For detailed documentation, 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. </td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>consumer.delay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>500</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Delay in milliseconds between each poll. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>consumer.initialDelay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>1000</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> Millis
econds before polling starts. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useFixedDelay</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Set to <tt>true</tt> to use fixed delay between polls, otherwise fixed 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.
</td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>maxMessagesPerPoll</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>0</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> An int
eger value to define the maximum number of messages to gather per poll. By
default, no maximum is set. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useIterator</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>true</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
If <tt>true</tt> each row returned when polling will be processed individually.
If <tt>false</tt> the entire <tt>java.util.List</tt> of data is set as the IN
body. </td></tr></tbody></table>
+<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1"
class="confluenceTh"> Option </th><th colspan="1" rowspan="1"
class="confluenceTh"> Type </th><th colspan="1" rowspan="1"
class="confluenceTh"> Default </th><th colspan="1" rowspan="1"
class="confluenceTh"> Description </th></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>batch</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.7.5, 2.8.4 and 2.9:</b> Execute SQL batch
update statements. See notes below on how the treatment of the inbound message
body changes if this is set to <tt>true</tt>. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>dataSourceRef</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>String</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>null</tt> </td><td colspan="1
" rowspan="1" class="confluenceTd"> Reference to a <tt>DataSource</tt> to look
up in the registry. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>placeholder</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>String</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>#</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.4:</b> Specifies a character that will be
replaced to <tt>?</tt> in SQL query. Notice, that it is simple
<tt>String.replaceAll()</tt> operation and no SQL parsing is involved (quoted
strings will also change) </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>template.<xxx></tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>null</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> Sets additional options on the Spring
<tt>JdbcTemplate</tt> that is used behind the scenes to execute the queries.
For instance, <tt>template.maxRows=10</tt>. For detailed documentation, 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. </td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>consumer.delay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>500</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Delay in milliseconds between each poll. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>consumer.initialDelay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>1000</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> Millis
econds before polling starts. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useFixedDelay</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Set to <tt>true</tt> to use fixed delay between polls, otherwise fixed 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.
</td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>maxMessagesPerPoll</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>0</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> An int
eger value to define the maximum number of messages to gather per poll. By
default, no maximum is set. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useIterator</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>true</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
If <tt>true</tt> each row returned when polling will be processed individually.
If <tt>false</tt> the entire <tt>java.util.List</tt> of data is set as the IN
body. </td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>consumer.routeEmptyResultSet</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> Whether to
route a single empty <a shape="r
ect" href="exchange.html" title="Exchange">Exchange</a> if there was no data
to poll. </td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>consumer.expectedUpdateCount</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>-1</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> If using
<tt>consumer.onConsume</tt> then this option can be used to set an expected
number of rows being updated. Typically you may set this to <tt>1</tt> to
expect one row to be updated. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.breakBatchOnConsumeFail</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> If using <tt>consumer.onCons
ume</tt> and it fails, then this option controls whether to break out of the
batch or continue processing the next row from the batch.
</td></tr></tbody></table>
</div>
</div>
Modified: websites/production/camel/content/cache/main.pageCache
==============================================================================
Binary files - no diff available.
Modified: websites/production/camel/content/sql-component.html
==============================================================================
--- websites/production/camel/content/sql-component.html (original)
+++ websites/production/camel/content/sql-component.html Thu Jan 17 13:24:45
2013
@@ -119,7 +119,7 @@ sql:select * from table where id=# order
<h3><a shape="rect" name="SQLComponent-Options"></a>Options</h3>
<div class="confluenceTableSmall"><div class="table-wrap">
-<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1"
class="confluenceTh"> Option </th><th colspan="1" rowspan="1"
class="confluenceTh"> Type </th><th colspan="1" rowspan="1"
class="confluenceTh"> Default </th><th colspan="1" rowspan="1"
class="confluenceTh"> Description </th></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>batch</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.7.5, 2.8.4 and 2.9:</b> Execute SQL batch
update statements. See notes below on how the treatment of the inbound message
body changes if this is set to <tt>true</tt>. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>dataSourceRef</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>String</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>null</tt> </td><td colspan="1
" rowspan="1" class="confluenceTd"> Reference to a <tt>DataSource</tt> to look
up in the registry. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>placeholder</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>String</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>#</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.4:</b> Specifies a character that will be
replaced to <tt>?</tt> in SQL query. Notice, that it is simple
<tt>String.replaceAll()</tt> operation and no SQL parsing is involved (quoted
strings will also change) </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>template.<xxx></tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>null</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> Sets additional options on the Spring
<tt>JdbcTemplate</tt> that is used behind the scenes to execute the queries.
For instance, <tt>template.maxRows=10</tt>. For detailed documentation, 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. </td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>consumer.delay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>500</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Delay in milliseconds between each poll. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>consumer.initialDelay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>1000</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> Millis
econds before polling starts. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useFixedDelay</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Set to <tt>true</tt> to use fixed delay between polls, otherwise fixed 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.
</td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>maxMessagesPerPoll</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>0</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> An int
eger value to define the maximum number of messages to gather per poll. By
default, no maximum is set. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useIterator</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>true</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
If <tt>true</tt> each row returned when polling will be processed individually.
If <tt>false</tt> the entire <tt>java.util.List</tt> of data is set as the IN
body. </td></tr></tbody></table>
+<table class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1"
class="confluenceTh"> Option </th><th colspan="1" rowspan="1"
class="confluenceTh"> Type </th><th colspan="1" rowspan="1"
class="confluenceTh"> Default </th><th colspan="1" rowspan="1"
class="confluenceTh"> Description </th></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>batch</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.7.5, 2.8.4 and 2.9:</b> Execute SQL batch
update statements. See notes below on how the treatment of the inbound message
body changes if this is set to <tt>true</tt>. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>dataSourceRef</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>String</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>null</tt> </td><td colspan="1
" rowspan="1" class="confluenceTd"> Reference to a <tt>DataSource</tt> to look
up in the registry. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>placeholder</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>String</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>#</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.4:</b> Specifies a character that will be
replaced to <tt>?</tt> in SQL query. Notice, that it is simple
<tt>String.replaceAll()</tt> operation and no SQL parsing is involved (quoted
strings will also change) </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>template.<xxx></tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>null</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> Sets additional options on the Spring
<tt>JdbcTemplate</tt> that is used behind the scenes to execute the queries.
For instance, <tt>template.maxRows=10</tt>. For detailed documentation, 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. </td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>consumer.delay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>500</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Delay in milliseconds between each poll. </td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>consumer.initialDelay</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>long</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>1000</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> Millis
econds before polling starts. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useFixedDelay</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
Set to <tt>true</tt> to use fixed delay between polls, otherwise fixed 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.
</td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>maxMessagesPerPoll</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>0</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> An int
eger value to define the maximum number of messages to gather per poll. By
default, no maximum is set. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.useIterator</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <tt>true</tt> </td><td colspan="1"
rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b>
If <tt>true</tt> each row returned when polling will be processed individually.
If <tt>false</tt> the entire <tt>java.util.List</tt> of data is set as the IN
body. </td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>consumer.routeEmptyResultSet</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>boolean</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>false</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> Whether to
route a single empty <a shape="r
ect" href="exchange.html" title="Exchange">Exchange</a> if there was no data
to poll. </td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd">
<tt>consumer.expectedUpdateCount</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>int</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>-1</tt> </td><td colspan="1" rowspan="1"
class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL consumer only:</b> If using
<tt>consumer.onConsume</tt> then this option can be used to set an expected
number of rows being updated. Typically you may set this to <tt>1</tt> to
expect one row to be updated. </td></tr><tr><td colspan="1" rowspan="1"
class="confluenceTd"> <tt>consumer.breakBatchOnConsumeFail</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>boolean</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <tt>false</tt> </td><td
colspan="1" rowspan="1" class="confluenceTd"> <b>Camel 2.11:</b> <b>SQL
consumer only:</b> If using <tt>consumer.onCons
ume</tt> and it fails, then this option controls whether to break out of the
batch or continue processing the next row from the batch.
</td></tr></tbody></table>
</div>
</div>
