camel-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From build...@apache.org
Subject svn commit: r846991 - in /websites/production/camel/content: book-component-appendix.html book-in-one-page.html cache/main.pageCache sql-component.html
Date Thu, 17 Jan 2013 12:24:49 GMT
Author: buildbot
Date: Thu Jan 17 12:24:48 2013
New Revision: 846991

Log:
Production update by buildbot for camel

Modified:
    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/book-component-appendix.html
==============================================================================
--- websites/production/camel/content/book-component-appendix.html (original)
+++ websites/production/camel/content/book-component-appendix.html Thu Jan 17 12:24:48 2013
@@ -16279,7 +16279,8 @@ $body$
 
 <h3><a shape="rect" name="BookComponentAppendix-URIformat"></a>URI format</h3>
 
-<div class="panelMacro"><table class="warningMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/forbidden.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">The
SQL component can only be used to define producer endpoints. In other words, you cannot define
an SQL endpoint in a <tt>from()</tt> statement.</td></tr></table></div>
+<div class="panelMacro"><table class="warningMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/forbidden.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">In
Camel 2.10 or older the SQL component can only be used as producer.<br clear="none">
+From Camel 2.11 onwards this component can also be a consumer, eg <tt>from()</tt>.</td></tr></table></div>
 
 <div class="panelMacro"><table class="infoMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/information.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">This
component can be used as a <a shape="rect" class="external-link" href="http://camel.apache.org/transactional-client.html">Transactional
Client</a>.</td></tr></table></div>
 
@@ -16297,10 +16298,10 @@ sql:select * from table where id=# order
 
 <h3><a shape="rect" name="BookComponentAppendix-Options"></a>Options</h3>
 
-<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.&lt;xxx&gt;</tt>
</td><td colspan="1" rowspan="1" class="confluenceTd">&#160;</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></tbody></table>
+<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.&lt;xxx&gt;</tt>
</td><td colspan="1" rowspan="1" class="confluenceTd">&#160;</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>
+</div>
 </div>
-
 
 <h3><a shape="rect" name="BookComponentAppendix-Treatmentofthemessagebody"></a>Treatment
of the message body</h3>
 

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 12:24:48 2013
@@ -36513,7 +36513,8 @@ $body$
 
 <h3><a shape="rect" name="BookInOnePage-URIformat"></a>URI format</h3>
 
-<div class="panelMacro"><table class="warningMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/forbidden.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">The
SQL component can only be used to define producer endpoints. In other words, you cannot define
an SQL endpoint in a <tt>from()</tt> statement.</td></tr></table></div>
+<div class="panelMacro"><table class="warningMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/forbidden.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">In
Camel 2.10 or older the SQL component can only be used as producer.<br clear="none">
+From Camel 2.11 onwards this component can also be a consumer, eg <tt>from()</tt>.</td></tr></table></div>
 
 <div class="panelMacro"><table class="infoMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/information.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">This
component can be used as a <a shape="rect" class="external-link" href="http://camel.apache.org/transactional-client.html">Transactional
Client</a>.</td></tr></table></div>
 
@@ -36531,10 +36532,10 @@ sql:select * from table where id=# order
 
 <h3><a shape="rect" name="BookInOnePage-Options"></a>Options</h3>
 
-<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.&lt;xxx&gt;</tt>
</td><td colspan="1" rowspan="1" class="confluenceTd">&#160;</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></tbody></table>
+<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.&lt;xxx&gt;</tt>
</td><td colspan="1" rowspan="1" class="confluenceTd">&#160;</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>
+</div>
 </div>
-
 
 <h3><a shape="rect" name="BookInOnePage-Treatmentofthemessagebody"></a>Treatment
of the message body</h3>
 

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 12:24:48 2013
@@ -99,7 +99,8 @@
 
 <h3><a shape="rect" name="SQLComponent-URIformat"></a>URI format</h3>
 
-<div class="panelMacro"><table class="warningMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/forbidden.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">The
SQL component can only be used to define producer endpoints. In other words, you cannot define
an SQL endpoint in a <tt>from()</tt> statement.</td></tr></table></div>
+<div class="panelMacro"><table class="warningMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/forbidden.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">In
Camel 2.10 or older the SQL component can only be used as producer.<br clear="none">
+From Camel 2.11 onwards this component can also be a consumer, eg <tt>from()</tt>.</td></tr></table></div>
 
 <div class="panelMacro"><table class="infoMacro"><colgroup span="1"><col
span="1" width="24"><col span="1"></colgroup><tr><td colspan="1" rowspan="1"
valign="top"><img align="middle" src="https://cwiki.apache.org/confluence/images/icons/emoticons/information.gif"
width="16" height="16" alt="" border="0"></td><td colspan="1" rowspan="1">This
component can be used as a <a shape="rect" class="external-link" href="http://camel.apache.org/transactional-client.html">Transactional
Client</a>.</td></tr></table></div>
 
@@ -117,10 +118,10 @@ sql:select * from table where id=# order
 
 <h3><a shape="rect" name="SQLComponent-Options"></a>Options</h3>
 
-<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.&lt;xxx&gt;</tt>
</td><td colspan="1" rowspan="1" class="confluenceTd">&#160;</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></tbody></table>
+<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.&lt;xxx&gt;</tt>
</td><td colspan="1" rowspan="1" class="confluenceTd">&#160;</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>
+</div>
 </div>
-
 
 <h3><a shape="rect" name="SQLComponent-Treatmentofthemessagebody"></a>Treatment
of the message body</h3>
 



Mime
View raw message