camel-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From build...@apache.org
Subject svn commit: r910065 - in /websites/production/camel/content: cache/main.pageCache camel-2140-release.html jdbc.html
Date Tue, 27 May 2014 07:17:54 GMT
Author: buildbot
Date: Tue May 27 07:17:54 2014
New Revision: 910065

Log:
Production update by buildbot for camel

Modified:
    websites/production/camel/content/cache/main.pageCache
    websites/production/camel/content/camel-2140-release.html
    websites/production/camel/content/jdbc.html

Modified: websites/production/camel/content/cache/main.pageCache
==============================================================================
Binary files - no diff available.

Modified: websites/production/camel/content/camel-2140-release.html
==============================================================================
--- websites/production/camel/content/camel-2140-release.html (original)
+++ websites/production/camel/content/camel-2140-release.html Tue May 27 07:17:54 2014
@@ -87,7 +87,7 @@
         <tr>
         <td valign="top" width="100%">
 <div class="wiki-content maincontent"><h1 id="Camel2.14.0Release-Camel2.14.0release(currentlyinprogress)">Camel
2.14.0 release (currently in progress)</h1><div style="padding-right:20px;float:left;margin-left:-20px;">
-<p><span class="image-wrap" style=""><img src="http://camel.apache.org/download.data/camel-box-v1.0-150x200.png"
style="border: 0px solid black"></span></p></div><div style="min-height:200px"></div><h2
id="Camel2.14.0Release-NewandNoteworthy">New and Noteworthy</h2><p>Welcome
to the 2.14.0 release which approx XXX issues resolved (new features, improvements and bug
fixes such as...)</p><ul><li>Simple language defined in routes using resultType
as boolean is now evaluated as predicate instead of as expression.</li><li>Introduced
RuntimeEndpointRegistry to capture runtime usage of endpoints in use during routing, such
as dynamic endpoints from dynamic <a shape="rect" href="eip.html">EIP</a>s.</li><li>Added
event notification for routes added and removed.</li><li>Allow to configure cache
size in Recipient List, Routing Slip and Dynamic Router EIPs; and as well turn caching off.</li><li><a
shape="rect" href="netty-http.html">Netty HTTP</a>&#160;producer now supports
the <span>CamelHttpP
 ath header to define a dynamic context-path and query parameters to call the remote http
server.</span></li><li><span><a shape="rect" href="polling-consumer.html">Polling
Consumer</a>&#160;allows to configure initial queue size and whether to block when
full when using the default&#160;<code>EventDrivenPollingConsumer</code> which
most components does. We now block by default, as otherwise the message may be lost if the
queue was full, and a new message was offered.</span></li><li><span><a
shape="rect" class="external-link" href="https://issues.apache.org/jira/browse/CAMEL-7435">Added</a>
a generic callback to configure the <a shape="rect" href="apns.html">APNS</a>
service builder.</span></li></ul><h3 id="Camel2.14.0Release-FixedIssues">Fixed
Issues</h3><ul><li>Timer consumer is now scheduled after CamelContext has
started all routes, to ensure other routes is running when timer routes is triggered to run.</li><li><a
shape="rect" href="netty-http.html">Netty HTTP</a> now returns HTT
 P status 404 if resource not found instead of 503.</li><li>Fixed the <a shape="rect"
class="external-link" href="https://camel.apache.org/mongodb.html">MongoDB</a>&#160;<code>readPreference</code>&#160;option
which used to cause an <code>IllegalArgumentException</code>&#160;to be thrown.</li><li>Fixed
issue with Netty producer may leak HashWhealTimer instances when having many producers that
are not reused.</li></ul><h3 id="Camel2.14.0Release-New">New <a shape="rect"
href="enterprise-integration-patterns.html">Enterprise Integration Patterns</a></h3><ul><li><a
shape="rect" href="load-balancer.html">Circuit Breaker</a> pattern implemented as
a Load Balancer policy</li></ul><h3 id="Camel2.14.0Release-New.1">New <a
shape="rect" href="components.html">Components</a></h3><ul><li>camel-ahc-ws</li><li>camel-atmosphere-websocket</li><li><a
shape="rect" href="openshift.html">camel-openshift</a></li></ul><h3
id="Camel2.14.0Release-New.2">New <a shape="rect" href="camel-maven-archetypes.html">
 Camel Maven Archetypes</a></h3><h3 id="Camel2.14.0Release-NewDSL">New DSL</h3><h3
id="Camel2.14.0Release-NewAnnotations">New Annotations</h3><h3 id="Camel2.14.0Release-NewDataFormats">New
<a shape="rect" href="data-format.html">Data Formats</a></h3><h3 id="Camel2.14.0Release-New.3">New
<a shape="rect" href="languages.html">Languages</a></h3><h3 id="Camel2.14.0Release-New.4">New
<a shape="rect" href="examples.html">Examples</a></h3><h3 id="Camel2.14.0Release-New.5">New
<a shape="rect" href="tutorials.html">Tutorials</a></h3><h3 id="Camel2.14.0Release-NewTooling">New
Tooling</h3><h2 id="Camel2.14.0Release-APIchanges">API changes</h2><ul><li>Changed
...</li></ul><h2 id="Camel2.14.0Release-KnownIssues">Known Issues</h2><ul><li>Spring
4.x is not yet official supported.</li></ul><h2 id="Camel2.14.0Release-DependencyUpgrades">Dependency
Upgrades</h2><p>You can see any dependency changes using <a shape="rect" class="external-link"
href="http://vdiff.notsoclever.cc/" rel="nofollow">Camel Dep
 endencies Version Differences web tool</a> created by Tracy Snell from the Camel <a
shape="rect" href="team.html">Team</a>.</p><p>The below list is a best
effort, and we may miss some updates, its better to use the <a shape="rect" class="external-link"
href="http://vdiff.notsoclever.cc/" rel="nofollow">Camel Dependencies Version Differences
web tool</a> which uses the released projects for comparison.</p><ul><li>Atomikos
3.9.2 to 3.9.3</li><li>Commons-codec 1.8 to 1.9</li><li>Dozer 5.4.0
to 5.5.1</li><li>Groovy upgraded to 2.3.0</li><li>JRuby 1.7.10 to
1.7.12</li><li>MongoDB-Java-Driver 2.11.4 to 2.12.0</li><li>Scala
2.10.3 to 2.10.4</li><li>RabbitMQ AMQ Client 3.2.2 to 3.3.0</li><li>CXF
2.7.11 to 3.0.0</li></ul><h2 id="Camel2.14.0Release-Internalchanges">Internal
changes</h2><ul><li>Changed ...</li></ul><h2 id="Camel2.14.0Release-Changesthatmayaffectendusers">Changes
that may affect end users</h2><ul><li><a shape="rect" href="polling-consumer.html">Polling
Consumer</a>&#160;allows 
 to configure initial queue size and whether to block when full when using the default&#160;<code>EventDrivenPollingConsumer</code>
which most components does. We now block by default, as otherwise the message may be lost
if the queue was full, and a new message was offered.</li></ul><h2 id="Camel2.14.0Release-Importantchangestoconsiderwhenupgrading">Important
changes to consider when upgrading</h2><ul><li>Bla bla<br clear="none"><br
clear="none"></li></ul><h2 id="Camel2.14.0Release-GettingtheDistributions">Getting
the Distributions</h2><h3 id="Camel2.14.0Release-BinaryDistributions">Binary Distributions</h3><div
class="table-wrap"><table class="confluenceTable"><tbody><tr><th colspan="1"
rowspan="1" class="confluenceTh"><p>Description</p></th><th colspan="1"
rowspan="1" class="confluenceTh"><p>Download Link</p></th><th colspan="1"
rowspan="1" class="confluenceTh"><p>PGP Signature file of download</p></th></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p>Windows Distributi
 on</p></td><td colspan="1" rowspan="1" class="confluenceTd"><p><a
shape="rect" class="external-link" href="http://www.apache.org/dyn/closer.cgi/camel/apache-camel/2.14.0/apache-camel-2.14.0.zip">apache-camel-2.14.0.zip</a></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dist/camel/apache-camel/2.14.0/apache-camel-2.14.0.zip.asc">apache-camel-2.14.0.zip.asc</a></p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p>Unix/Linux/Cygwin Distribution</p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dyn/closer.cgi/camel/apache-camel/2.14.0/apache-camel-2.14.0.tar.gz">apache-camel-2.14.0.tar.gz</a></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dist/camel/apache-camel/2.14.0/apache-camel-2.14.0.tar.gz.asc">apache-camel-2.14.0.tar.gz.asc</a></p></t
 d></tr></tbody></table></div><h3 id="Camel2.14.0Release-SourceDistribution">Source
Distribution</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th
colspan="1" rowspan="1" class="confluenceTh"><p>Description</p></th><th
colspan="1" rowspan="1" class="confluenceTh"><p>Download Link</p></th><th
colspan="1" rowspan="1" class="confluenceTh"><p>PGP Signature file of download</p></th></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p>Source</p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dyn/closer.cgi/camel/apache-camel/2.14.0/apache-camel-2.14.0-src.zip">apache-camel-2.14.0-src.zip</a></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dist/camel/apache-camel/2.14.0/apache-camel-2.14.0-src.zip.asc">apache-camel-2.14.0-src.zip.asc</a></p></td></tr></tbody></table></div><h3
id="Camel2.14.0Release-Gettingthe
 BinariesusingMaven2">Getting the Binaries using Maven 2</h3><p>To use this
release in your maven project, the proper dependency configuration that you should use in
your <a shape="rect" class="external-link" href="http://maven.apache.org/guides/introduction/introduction-to-the-pom.html">Maven
POM</a> is:</p><div class="code panel pdl" style="border-width: 1px;"><div
class="codeContent panelContent pdl">
+<p><span class="image-wrap" style=""><img src="http://camel.apache.org/download.data/camel-box-v1.0-150x200.png"
style="border: 0px solid black"></span></p></div><div style="min-height:200px"></div><h2
id="Camel2.14.0Release-NewandNoteworthy">New and Noteworthy</h2><p>Welcome
to the 2.14.0 release which approx XXX issues resolved (new features, improvements and bug
fixes such as...)</p><ul><li>Simple language defined in routes using resultType
as boolean is now evaluated as predicate instead of as expression.</li><li>Introduced
RuntimeEndpointRegistry to capture runtime usage of endpoints in use during routing, such
as dynamic endpoints from dynamic <a shape="rect" href="eip.html">EIP</a>s.</li><li>Added
event notification for routes added and removed.</li><li>Allow to configure cache
size in Recipient List, Routing Slip and Dynamic Router EIPs; and as well turn caching off.</li><li><a
shape="rect" href="netty-http.html">Netty HTTP</a>&#160;producer now supports
the <span>CamelHttpP
 ath header to define a dynamic context-path and query parameters to call the remote http
server.</span></li><li><span><a shape="rect" href="polling-consumer.html">Polling
Consumer</a>&#160;allows to configure initial queue size and whether to block when
full when using the default&#160;<code>EventDrivenPollingConsumer</code> which
most components does. We now block by default, as otherwise the message may be lost if the
queue was full, and a new message was offered.</span></li><li><span><a
shape="rect" class="external-link" href="https://issues.apache.org/jira/browse/CAMEL-7435">Added</a>
a generic callback to configure the <a shape="rect" href="apns.html">APNS</a>
service builder.</span></li><li><span>Added&#160;<code>StreamList</code>
option to the&#160;<a shape="rect" href="jdbc.html">JDBC</a> component</span></li></ul><h3
id="Camel2.14.0Release-FixedIssues">Fixed Issues</h3><ul><li>Timer consumer
is now scheduled after CamelContext has started all routes, to ensure other routes 
 is running when timer routes is triggered to run.</li><li><a shape="rect"
href="netty-http.html">Netty HTTP</a> now returns HTTP status 404 if resource not
found instead of 503.</li><li>Fixed the <a shape="rect" class="external-link"
href="https://camel.apache.org/mongodb.html">MongoDB</a>&#160;<code>readPreference</code>&#160;option
which used to cause an <code>IllegalArgumentException</code>&#160;to be thrown.</li><li>Fixed
issue with Netty producer may leak HashWhealTimer instances when having many producers that
are not reused.</li></ul><h3 id="Camel2.14.0Release-New">New <a shape="rect"
href="enterprise-integration-patterns.html">Enterprise Integration Patterns</a></h3><ul><li><a
shape="rect" href="load-balancer.html">Circuit Breaker</a> pattern implemented as
a Load Balancer policy</li></ul><h3 id="Camel2.14.0Release-New.1">New <a
shape="rect" href="components.html">Components</a></h3><ul><li>camel-ahc-ws</li><li>camel-atmosphere-websocket</li><li><a
shape="rect" href="openshi
 ft.html">camel-openshift</a></li></ul><h3 id="Camel2.14.0Release-New.2">New
<a shape="rect" href="camel-maven-archetypes.html">Camel Maven Archetypes</a></h3><h3
id="Camel2.14.0Release-NewDSL">New DSL</h3><h3 id="Camel2.14.0Release-NewAnnotations">New
Annotations</h3><h3 id="Camel2.14.0Release-NewDataFormats">New <a shape="rect"
href="data-format.html">Data Formats</a></h3><h3 id="Camel2.14.0Release-New.3">New
<a shape="rect" href="languages.html">Languages</a></h3><h3 id="Camel2.14.0Release-New.4">New
<a shape="rect" href="examples.html">Examples</a></h3><h3 id="Camel2.14.0Release-New.5">New
<a shape="rect" href="tutorials.html">Tutorials</a></h3><h3 id="Camel2.14.0Release-NewTooling">New
Tooling</h3><h2 id="Camel2.14.0Release-APIchanges">API changes</h2><ul><li>Changed
...</li></ul><h2 id="Camel2.14.0Release-KnownIssues">Known Issues</h2><ul><li>Spring
4.x is not yet official supported.</li></ul><h2 id="Camel2.14.0Release-DependencyUpgrades">Dependency
Upgrades</h2><p>You can see 
 any dependency changes using <a shape="rect" class="external-link" href="http://vdiff.notsoclever.cc/"
rel="nofollow">Camel Dependencies Version Differences web tool</a> created by Tracy
Snell from the Camel <a shape="rect" href="team.html">Team</a>.</p><p>The
below list is a best effort, and we may miss some updates, its better to use the <a shape="rect"
class="external-link" href="http://vdiff.notsoclever.cc/" rel="nofollow">Camel Dependencies
Version Differences web tool</a> which uses the released projects for comparison.</p><ul><li>Atomikos
3.9.2 to 3.9.3</li><li>Commons-codec 1.8 to 1.9</li><li>Dozer 5.4.0
to 5.5.1</li><li>Groovy upgraded to 2.3.0</li><li>JRuby 1.7.10 to
1.7.12</li><li>MongoDB-Java-Driver 2.11.4 to 2.12.0</li><li>Scala
2.10.3 to 2.10.4</li><li>RabbitMQ AMQ Client 3.2.2 to 3.3.0</li><li>CXF
2.7.11 to 3.0.0</li></ul><h2 id="Camel2.14.0Release-Internalchanges">Internal
changes</h2><ul><li>Changed ...</li></ul><h2 id="Camel2.14.0Release-Changesthatmayaffectenduser
 s">Changes that may affect end users</h2><ul><li><a shape="rect"
href="polling-consumer.html">Polling Consumer</a>&#160;allows to configure initial
queue size and whether to block when full when using the default&#160;<code>EventDrivenPollingConsumer</code>
which most components does. We now block by default, as otherwise the message may be lost
if the queue was full, and a new message was offered.</li></ul><h2 id="Camel2.14.0Release-Importantchangestoconsiderwhenupgrading">Important
changes to consider when upgrading</h2><ul><li>Bla bla<br clear="none"><br
clear="none"></li></ul><h2 id="Camel2.14.0Release-GettingtheDistributions">Getting
the Distributions</h2><h3 id="Camel2.14.0Release-BinaryDistributions">Binary Distributions</h3><div
class="table-wrap"><table class="confluenceTable"><tbody><tr><th colspan="1"
rowspan="1" class="confluenceTh"><p>Description</p></th><th colspan="1"
rowspan="1" class="confluenceTh"><p>Download Link</p></th><th colspan="1"
rowspan="1" class="confluen
 ceTh"><p>PGP Signature file of download</p></th></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p>Windows Distribution</p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dyn/closer.cgi/camel/apache-camel/2.14.0/apache-camel-2.14.0.zip">apache-camel-2.14.0.zip</a></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dist/camel/apache-camel/2.14.0/apache-camel-2.14.0.zip.asc">apache-camel-2.14.0.zip.asc</a></p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p>Unix/Linux/Cygwin Distribution</p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dyn/closer.cgi/camel/apache-camel/2.14.0/apache-camel-2.14.0.tar.gz">apache-camel-2.14.0.tar.gz</a></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href=
 "http://www.apache.org/dist/camel/apache-camel/2.14.0/apache-camel-2.14.0.tar.gz.asc">apache-camel-2.14.0.tar.gz.asc</a></p></td></tr></tbody></table></div><h3
id="Camel2.14.0Release-SourceDistribution">Source Distribution</h3><div class="table-wrap"><table
class="confluenceTable"><tbody><tr><th colspan="1" rowspan="1" class="confluenceTh"><p>Description</p></th><th
colspan="1" rowspan="1" class="confluenceTh"><p>Download Link</p></th><th
colspan="1" rowspan="1" class="confluenceTh"><p>PGP Signature file of download</p></th></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p>Source</p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dyn/closer.cgi/camel/apache-camel/2.14.0/apache-camel-2.14.0-src.zip">apache-camel-2.14.0-src.zip</a></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><a shape="rect" class="external-link"
href="http://www.apache.org/dist/camel/apache-camel/2.14.0/apache-camel-2
 .14.0-src.zip.asc">apache-camel-2.14.0-src.zip.asc</a></p></td></tr></tbody></table></div><h3
id="Camel2.14.0Release-GettingtheBinariesusingMaven2">Getting the Binaries using Maven
2</h3><p>To use this release in your maven project, the proper dependency configuration
that you should use in your <a shape="rect" class="external-link" href="http://maven.apache.org/guides/introduction/introduction-to-the-pom.html">Maven
POM</a> is:</p><div class="code panel pdl" style="border-width: 1px;"><div
class="codeContent panelContent pdl">
 <script class="theme: Default; brush: xml; gutter: false" type="syntaxhighlighter"><![CDATA[&lt;dependency&gt;
   &lt;groupId&gt;org.apache.camel&lt;/groupId&gt;
   &lt;artifactId&gt;camel-core&lt;/artifactId&gt;

Modified: websites/production/camel/content/jdbc.html
==============================================================================
--- websites/production/camel/content/jdbc.html (original)
+++ websites/production/camel/content/jdbc.html Tue May 27 07:17:54 2014
@@ -108,7 +108,8 @@
 a) If the query has only single column, then that JDBC Column object is returned. (such as
SELECT COUNT( * ) FROM PROJECT 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">
 c) If the outputClass is set, then it will convert the query result into an Java bean object
by calling all the setters that match the column names. It will assume your class has a default
constructor to create instance with.<br clear="none">
-d) If the query resulted in more than one rows, it throws an non-unique result exception.</p></td></tr><tr><td></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p> <code>outputClass</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.12.1:</strong> Specify the full package and class name to use as conversion when outputType=SelectOne.
</p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p>
<code>beanRowMapper</code> </p></td><td colspan="1" rowspan="1"
class="confluenceTd"><p>&#160;</p></td><td colspan="1" rowspan="1"
class="confluenceTd"><p> <strong>Camel 2.12.1:</strong> To use a custom
<code>org.apache.camel.component.jdbc.BeanRowMapper</code> when using <code>outputClass</code>.
The default implementation will lower case the row names and skip underscores, and dashes.
For example <code>"CUST_ID"</code> is mapped as <code>"custId"</code>.
<
 /p></td></tr></tbody></table>
+d) If the query resulted in more than one rows, it throws an non-unique result exception.<br
clear="none">
+<strong>Camel 2.14.0:</strong> New <code>StreamList</code> output
type value that streams the result of the query using an <code>Iterator&lt;Map&lt;String,
Object&gt;&gt;</code>, it can be used along with the <a shape="rect" href="splitter.html"
title="Splitter">Splitter</a> EIP. </p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p> <code>outputClass</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.12.1:</strong> Specify the full package and class name to use as conversion when outputType=SelectOne.
</p></td></tr><tr><td colspan="1" rowspan="1" class="confluenceTd"><p>
<code>beanRowMapper</code> </p></td><td colspan="1" rowspan="1"
class="confluenceTd"><p>&#160;</p></td><td colspan="1" rowspan="1"
class="confluenceTd"><p> <strong>Camel 2.12.1:</strong> To use a custom
<code>org.apache.camel.component.jdbc.BeanRowMapper</code> when using <code>outputCla
 ss</code>. The default implementation will lower case the row names and skip underscores,
and dashes. For example <code>"CUST_ID"</code> is mapped as <code>"custId"</code>.
</p></td></tr></tbody></table>
 </div><h3 id="JDBC-Result">Result</h3><p>By default the result is
returned in the OUT body as an <code>ArrayList&lt;HashMap&lt;String, Object&gt;&gt;</code>.
The <code>List</code> object contains the list of rows and the <code>Map</code>
objects contain each row with the <code>String</code> key as the column name.
You can use the option <code>outputType</code> to control the result.</p><p><strong>Note:</strong>
This component fetches <code>ResultSetMetaData</code> to be able to return the
column name as the key in the <code>Map</code>.</p><h4 id="JDBC-MessageHeaders">Message
Headers</h4><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th
colspan="1" rowspan="1" class="confluenceTh"><p>Header</p></th><th
colspan="1" rowspan="1" class="confluenceTh"><p>Description</p></th></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p><code>CamelJdbcRowCount</code></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p>If the query is a <code>SELECT</code>,
query t
 he row count is returned in this OUT header.</p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p><code>CamelJdbcUpdateCount</code></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p>If the query is an <code>UPDATE</code>,
query the update count is returned in this OUT header.</p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p><code>CamelGeneratedKeysRows</code></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><strong>Camel 2.10:</strong>
Rows that contains the generated kets.</p></td></tr><tr><td colspan="1"
rowspan="1" class="confluenceTd"><p><code>CamelGeneratedKeysRowCount</code></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><strong>Camel 2.10:</strong>
The number of rows in the header that contains generated keys.</p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p><code>CamelJdbcColumnNames</code></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><strong>Camel 2.11.1:</strong>
The co
 lumn names from the ResultSet as a <code>java.util.Set</code> type.</p></td></tr><tr><td
colspan="1" rowspan="1" class="confluenceTd"><p><code>CamelJdbcParametes</code></p></td><td
colspan="1" rowspan="1" class="confluenceTd"><p><strong>Camel 2.12:</strong>
A <code>java.util.Map</code> which has the headers to be used if <code>useHeadersAsParameters</code>
has been enabled.</p></td></tr></tbody></table></div><h3
id="JDBC-Generatedkeys">Generated keys</h3><p><strong>Available as of
Camel 2.10</strong></p><p>If you insert data using SQL INSERT, then the
RDBMS may support auto generated keys. You can instruct the <a shape="rect" href="jdbc.html">JDBC</a>
producer to return the generated keys in headers.<br clear="none"> To do that set the
header <code>CamelRetrieveGeneratedKeys=true</code>. Then the generated keys will
be provided as headers with the keys listed in the table above.</p><p>You can
see more details in this <a shape="rect" class="external-link" href="https://svn.apache.org
 /repos/asf/camel/trunk/components/camel-jdbc/src/test/java/org/apache/camel/component/jdbc/JdbcGeneratedKeysTest.java">unit
test</a>.</p>    <div class="aui-message hint shadowed information-macro">
                             <span class="aui-icon icon-hint">Icon</span>
                 <div class="message-content">
@@ -178,7 +179,7 @@ row = data.get(1);
 assertEquals(&quot;cust2&quot;, row.get(&quot;ID&quot;));
 assertEquals(&quot;nsandhu&quot;, row.get(&quot;NAME&quot;));
 ]]></script>
-</div></div><p>If you want to work on the rows one by one instead of the
entire ResultSet at once you need to use the <a shape="rect" href="splitter.html">Splitter</a>
EIP such as:</p><div class="code panel pdl" style="border-width: 1px;"><div
class="codeContent panelContent pdl">
+</div></div><p>If you want to work on the rows one by one instead of the
entire ResultSet at once you need to use the <a shape="rect" href="splitter.html">Splitter</a>
EIP such as:</p><p>In Camel 2.13.x or older</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(&quot;direct:hello&quot;)
         // here we split the data from the testdb into new messages one by one
@@ -186,10 +187,19 @@ from(&quot;direct:hello&quot;)
     .to(&quot;jdbc:testdb&quot;).split(body()).to(&quot;mock:result&quot;);
 
 ]]></script>
-</div></div><h3 id="JDBC-Sample-Pollingthedatabaseeveryminute">Sample -
Polling the database every minute</h3><p>If we want to poll a database using the
JDBC component, we need to combine it with a polling scheduler such as the <a shape="rect"
href="timer.html">Timer</a> or <a shape="rect" href="quartz.html">Quartz</a>
etc. In the following example, we retrieve data from the database every 60 seconds:</p><div
class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent
pdl">
+</div></div><p>In Camel 2.14.x or newer</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(&quot;direct:hello&quot;)
+// here we split the data from the testdb into new messages one by one
+// so the mock endpoint will receive a message per row in the table
+// the StreamList option allows to stream the result of the query without creating a List
of rows
+// and notice we also enable streaming mode on the splitter
+.to(&quot;jdbc:testdb?outputType=StreamList&quot;)
+  .split(body()).streaming()
+  .to(&quot;mock:result&quot;);]]></script>
+</div></div><h3 id="JDBC-Sample-Pollingthedatabaseeveryminute"><br clear="none"><span
style="font-size: 16.0px;line-height: 1.5625;">Sample - Polling the database every minute</span></h3><p>If
we want to poll a database using the JDBC component, we need to combine it with a polling
scheduler such as the <a shape="rect" href="timer.html">Timer</a> or <a shape="rect"
href="quartz.html">Quartz</a> etc. In the following example, we retrieve data from
the database every 60 seconds:</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(&quot;timer://foo?period=60000&quot;).setBody(constant(&quot;select
* from customer&quot;)).to(&quot;jdbc:testdb&quot;).to(&quot;activemq:queue:customers&quot;);
 ]]></script>
-</div></div><p></p><h3 id="JDBC-SeeAlso">See Also</h3>
+</div></div><p>&#160;</p><p></p><h3 id="JDBC-SeeAlso">See
Also</h3>
 <ul><li><a shape="rect" href="configuring-camel.html">Configuring Camel</a></li><li><a
shape="rect" href="component.html">Component</a></li><li><a shape="rect"
href="endpoint.html">Endpoint</a></li><li><a shape="rect" href="getting-started.html">Getting
Started</a></li></ul><ul class="alternate"><li><a shape="rect"
href="sql.html">SQL</a></li></ul></div>
         </td>
         <td valign="top">



Mime
View raw message