This is an automated email from the ASF dual-hosted git repository.
ntimofeev pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/cayenne-website.git
The following commit(s) were added to refs/heads/master by this push:
new c797bbf Update 4.1 docs
c797bbf is described below
commit c797bbf5cfb18a69d0724fa0d24ecb2316488716
Author: Nikita Timofeev <[email protected]>
AuthorDate: Wed Jul 22 12:46:53 2020 +0300
Update 4.1 docs
---
src/main/site/content/docs/4.1/cayenne-guide.html | 23 +++++++++++++++++++++--
1 file changed, 21 insertions(+), 2 deletions(-)
diff --git a/src/main/site/content/docs/4.1/cayenne-guide.html
b/src/main/site/content/docs/4.1/cayenne-guide.html
index 96e5524..02ee853 100644
--- a/src/main/site/content/docs/4.1/cayenne-guide.html
+++ b/src/main/site/content/docs/4.1/cayenne-guide.html
@@ -60,7 +60,7 @@ menu:
<tr>
<td class="tableblock halign-left valign-top"><p
class="tableblock">4.1</p></td>
<td class="tableblock halign-left valign-top"><p
class="tableblock">Java 1.8 or newer</p></td>
- <td class="tableblock halign-left valign-top"><p
class="tableblock">Beta</p></td>
+ <td class="tableblock halign-left valign-top"><p
class="tableblock">Stable</p></td>
</tr>
<tr>
<td class="tableblock halign-left valign-top"><p
class="tableblock">4.0</p></td>
@@ -70,7 +70,7 @@ menu:
<tr>
<td class="tableblock halign-left valign-top"><p
class="tableblock">3.1</p></td>
<td class="tableblock halign-left valign-top"><p
class="tableblock">Java 1.5 or newer</p></td>
- <td class="tableblock halign-left valign-top"><p
class="tableblock">Stable</p></td>
+ <td class="tableblock halign-left valign-top"><p
class="tableblock">Aging</p></td>
</tr>
<tr>
<td class="tableblock halign-left valign-top"><p
class="tableblock">3.0</p></td>
@@ -2490,6 +2490,25 @@ for(DataRow row : rows) {
}</code></pre>
</div>
</div>
+ <div class="sect4">
+ <h5 id="mysql-jdbc-driver-and-iterated-queries"><a class="anchor"
href="#mysql-jdbc-driver-and-iterated-queries"></a>2.8.4.1. MySQL JDBC driver
and iterated queries</h5>
+ <div class="paragraph">
+ <p>The MySQL JDBC driver is known to pull the entire ResultSet into
memory. In order to get the driver to stream the results, append the JDBC
parameter <code>useCursorFetch=true</code> to the JDBC URL.</p>
+ </div>
+ <div class="paragraph">
+ <p>A fetch size must also be set when doing the query using
<code>ObjectSelect.statementFetchSize(..)</code>, for example:</p>
+ </div>
+ <div class="listingblock">
+ <div class="content">
+ <pre class="highlight"><code class="language-java java"
data-lang="java">ObjectSelect.query(queryClass)
+ .statementFetchSize(50000)
+ .iterate(objectContext, cayenneObject -> ...</code></pre>
+ </div>
+ </div>
+ <div class="paragraph">
+ <p>Adjust the value of the fetch size to fit requirements. A larger
value is more performant, but consumes more memory as well.</p>
+ </div>
+ </div>
</div>
<div class="sect3">
<h4 id="paginated-queries"><a class="anchor"
href="#paginated-queries"></a>2.8.5. Paginated Queries</h4>