Google Git
Sign in
apache / cayenne-website / 017cf03748c43ba409f0544b0c0a0f42b7e1cddc / . / src / main / site / static / docs / 4.0 / api / org / apache / cayenne / query / SQLSelect.html
blob: 04710fc1bde4d76720ef3f96a6cf82b4d19c86d5 [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc (1.8.0_112) on Mon Oct 14 11:36:14 MSK 2019 -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>SQLSelect (cayenne-doc: Cayenne Documentation 4.0.2 API)</title>
<meta name="date" content="2019-10-14">
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
<script type="text/javascript" src="../../../../script.js"></script>
</head>
<body>
<script type="text/javascript"><!--
try {
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="SQLSelect (cayenne-doc: Cayenne Documentation 4.0.2 API)";
}
}
catch(err) {
}
//-->
var methods = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"i7":9,"i8":9,"i9":10,"i10":10,"i11":10,"i12":10,"i13":10,"i14":10,"i15":10,"i16":10,"i17":10,"i18":10,"i19":10,"i20":10,"i21":10,"i22":10,"i23":10,"i24":10,"i25":10,"i26":10,"i27":10,"i28":10,"i29":10,"i30":10,"i31":10,"i32":10,"i33":9,"i34":9,"i35":9,"i36":10,"i37":10,"i38":10,"i39":10,"i40":10,"i41":10,"i42":10};
var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]};
var altColor = "altColor";
var rowColor = "rowColor";
var tableTab = "tableTab";
var activeTableTab = "activeTableTab";
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar.top">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div>
<a name="navbar.top.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/SQLSelect.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../index-all.html">Index</a></li>
<li><a href="../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../org/apache/cayenne/query/SQLExec.html" title="class in org.apache.cayenne.query"><span class="typeNameLink">Prev&nbsp;Class</span></a></li>
<li><a href="../../../../org/apache/cayenne/query/SQLTemplate.html" title="class in org.apache.cayenne.query"><span class="typeNameLink">Next&nbsp;Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../index.html?org/apache/cayenne/query/SQLSelect.html" target="_top">Frames</a></li>
<li><a href="SQLSelect.html" target="_top">No&nbsp;Frames</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../allclasses-noframe.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_top");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&nbsp;|&nbsp;</li>
<li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a name="skip.navbar.top">
<!-- -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<div class="subTitle">org.apache.cayenne.query</div>
<h2 title="Class SQLSelect" class="title">Class SQLSelect&lt;T&gt;</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li><a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</a></li>
<li>
<ul class="inheritance">
<li><a href="../../../../org/apache/cayenne/query/IndirectQuery.html" title="class in org.apache.cayenne.query">org.apache.cayenne.query.IndirectQuery</a></li>
<li>
<ul class="inheritance">
<li>org.apache.cayenne.query.SQLSelect&lt;T&gt;</li>
</ul>
</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
<dd><a href="https://docs.oracle.com/javase/7/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io">Serializable</a>, <a href="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</a>, <a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;T&gt;</dd>
</dl>
<hr>
<br>
<pre>public class <span class="typeNameLabel">SQLSelect&lt;T&gt;</span>
extends <a href="../../../../org/apache/cayenne/query/IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a>
implements <a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;T&gt;</pre>
<div class="block">A selecting query based on raw SQL and featuring fluent API.</div>
<dl>
<dt><span class="simpleTagLabel">Since:</span></dt>
<dd>4.0</dd>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="../../../../serialized-form.html#org.apache.cayenne.query.SQLSelect">Serialized Form</a></dd>
</dl>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== FIELD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="field.summary">
<!-- -->
</a>
<h3>Field Summary</h3>
<table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#cacheGroup">cacheGroup</a></span></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected <a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#cacheStrategy">cacheStrategy</a></span></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="../../../../org/apache/cayenne/query/CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#columnNameCaps">columnNameCaps</a></span></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#dataMapName">dataMapName</a></span></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#limit">limit</a></span></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#offset">offset</a></span></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#pageSize">pageSize</a></span></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>,<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#params">params</a></span></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#persistentType">persistentType</a></span></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#positionalParams">positionalParams</a></span></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#scalarType">scalarType</a></span></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/StringBuilder.html?is-external=true" title="class or interface in java.lang">StringBuilder</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#sqlBuffer">sqlBuffer</a></span></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#statementFetchSize">statementFetchSize</a></span></code>&nbsp;</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="fields.inherited.from.class.org.apache.cayenne.query.IndirectQuery">
<!-- -->
</a>
<h3>Fields inherited from class&nbsp;org.apache.cayenne.query.<a href="../../../../org/apache/cayenne/query/IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></h3>
<code><a href="../../../../org/apache/cayenne/query/IndirectQuery.html#dataMap">dataMap</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#lastResolver">lastResolver</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#name">name</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#replacementQuery">replacementQuery</a></code></li>
</ul>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor.summary">
<!-- -->
</a>
<h3>Constructor Summary</h3>
<table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colOne" scope="col">Constructor and Description</th>
</tr>
<tr class="altColor">
<td class="colOne"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#SQLSelect-java.lang.Class-java.lang.String-">SQLSelect</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;persistentType,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colOne"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#SQLSelect-java.lang.String-">SQLSelect</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>&nbsp;</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method.summary">
<!-- -->
</a>
<h3>Method Summary</h3>
<table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd">&nbsp;</span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr id="i0" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#append-java.lang.String-">append</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sqlChunk)</code>
<div class="block">Appends a piece of SQL to the previously stored SQL template.</div>
</td>
</tr>
<tr id="i1" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/ResultBatchIterator.html" title="class in org.apache.cayenne">ResultBatchIterator</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#batchIterator-org.apache.cayenne.ObjectContext-int-">batchIterator</a></span>(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context,
int&nbsp;size)</code>
<div class="block">Creates a ResultBatchIterator based on the provided context and batch
size.</div>
</td>
</tr>
<tr id="i2" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#cacheGroup-java.lang.String-">cacheGroup</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</code>&nbsp;</td>
</tr>
<tr id="i3" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#cacheStrategy-org.apache.cayenne.query.QueryCacheStrategy-">cacheStrategy</a></span>(<a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a>&nbsp;strategy)</code>&nbsp;</td>
</tr>
<tr id="i4" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#cacheStrategy-org.apache.cayenne.query.QueryCacheStrategy-java.lang.String-">cacheStrategy</a></span>(<a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a>&nbsp;strategy,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</code>&nbsp;</td>
</tr>
<tr id="i5" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#columnNameCaps-org.apache.cayenne.query.CapsStrategy-">columnNameCaps</a></span>(<a href="../../../../org/apache/cayenne/query/CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a>&nbsp;columnNameCaps)</code>
<div class="block">Sets a column name capitalization policy applied to selecting queries.</div>
</td>
</tr>
<tr id="i6" class="altColor">
<td class="colFirst"><code>protected <a href="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#createReplacementQuery-org.apache.cayenne.map.EntityResolver-">createReplacementQuery</a></span>(<a href="../../../../org/apache/cayenne/map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a>&nbsp;resolver)</code>
<div class="block">Creates a substitute query.</div>
</td>
</tr>
<tr id="i7" class="rowColor">
<td class="colFirst"><code>static <a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/DataRow.html" title="class in org.apache.cayenne">DataRow</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#dataRowQuery-java.lang.String-">dataRowQuery</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>
<div class="block">Creates a query that selects DataRows and uses default routing.</div>
</td>
</tr>
<tr id="i8" class="altColor">
<td class="colFirst"><code>static <a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/DataRow.html" title="class in org.apache.cayenne">DataRow</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#dataRowQuery-java.lang.String-java.lang.String-">dataRowQuery</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;dataMapName,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>
<div class="block">Creates a query that selects DataRows and uses routing based on the
provided DataMap name.</div>
</td>
</tr>
<tr id="i9" class="rowColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getCacheGroup--">getCacheGroup</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i10" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getCacheStrategy--">getCacheStrategy</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i11" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getColumnNameCaps--">getColumnNameCaps</a></span>()</code>
<div class="block">Returns a column name capitalization policy applied to selecting queries.</div>
</td>
</tr>
<tr id="i12" class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getLimit--">getLimit</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i13" class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getOffset--">getOffset</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i14" class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getPageSize--">getPageSize</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i15" class="rowColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/7/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>,<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getParams--">getParams</a></span>()</code>
<div class="block">Returns a potentially immmutable map of named parameters that will be
bound to SQL.</div>
</td>
</tr>
<tr id="i16" class="altColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getPositionalParams--">getPositionalParams</a></span>()</code>
<div class="block">Returns a potentially immmutable list of positional parameters that will
be bound to SQL.</div>
</td>
</tr>
<tr id="i17" class="rowColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getSql--">getSql</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i18" class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#getStatementFetchSize--">getStatementFetchSize</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i19" class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#isFetchingDataRows--">isFetchingDataRows</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i20" class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#isFetchingScalars--">isFetchingScalars</a></span>()</code>&nbsp;</td>
</tr>
<tr id="i21" class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#iterate-org.apache.cayenne.ObjectContext-org.apache.cayenne.ResultIteratorCallback-">iterate</a></span>(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context,
<a href="../../../../org/apache/cayenne/ResultIteratorCallback.html" title="interface in org.apache.cayenne">ResultIteratorCallback</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;callback)</code>
<div class="block">Creates a ResultIterator based on the provided context and passes it to a
callback for processing.</div>
</td>
</tr>
<tr id="i22" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/ResultIterator.html" title="interface in org.apache.cayenne">ResultIterator</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#iterator-org.apache.cayenne.ObjectContext-">iterator</a></span>(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</code>
<div class="block">Creates a ResultIterator based on the provided context.</div>
</td>
</tr>
<tr id="i23" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#limit-int-">limit</a></span>(int&nbsp;fetchLimit)</code>&nbsp;</td>
</tr>
<tr id="i24" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#localCache--">localCache</a></span>()</code>
<div class="block">Instructs Cayenne to look for query results in the "local" cache when
running the query.</div>
</td>
</tr>
<tr id="i25" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#localCache-java.lang.String-">localCache</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</code>
<div class="block">Instructs Cayenne to look for query results in the "local" cache when
running the query.</div>
</td>
</tr>
<tr id="i26" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#lowerColumnNames--">lowerColumnNames</a></span>()</code>
<div class="block">Equivalent of setting <a href="../../../../org/apache/cayenne/query/CapsStrategy.html#LOWER"><code>CapsStrategy.LOWER</code></a></div>
</td>
</tr>
<tr id="i27" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#offset-int-">offset</a></span>(int&nbsp;fetchOffset)</code>&nbsp;</td>
</tr>
<tr id="i28" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#pageSize-int-">pageSize</a></span>(int&nbsp;pageSize)</code>&nbsp;</td>
</tr>
<tr id="i29" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#params-java.util.Map-">params</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>,?&gt;&nbsp;parameters)</code>&nbsp;</td>
</tr>
<tr id="i30" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#params-java.lang.String-java.lang.Object-">params</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;name,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&nbsp;value)</code>&nbsp;</td>
</tr>
<tr id="i31" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#paramsArray-java.lang.Object...-">paramsArray</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>...&nbsp;params)</code>
<div class="block">Initializes positional parameters of the query.</div>
</td>
</tr>
<tr id="i32" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#paramsList-java.util.List-">paramsList</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;&nbsp;params)</code>
<div class="block">Initializes positional parameters of the query.</div>
</td>
</tr>
<tr id="i33" class="rowColor">
<td class="colFirst"><code>static &lt;T&gt;&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;T&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#query-java.lang.Class-java.lang.String-">query</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;T&gt;&nbsp;type,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>
<div class="block">Creates a query that selects DataObjects.</div>
</td>
</tr>
<tr id="i34" class="altColor">
<td class="colFirst"><code>static &lt;T&gt;&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;T&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#scalarQuery-java.lang.Class-java.lang.String-">scalarQuery</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;T&gt;&nbsp;type,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>
<div class="block">Creates a query that selects scalar values and uses default routing.</div>
</td>
</tr>
<tr id="i35" class="rowColor">
<td class="colFirst"><code>static &lt;T&gt;&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;T&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#scalarQuery-java.lang.Class-java.lang.String-java.lang.String-">scalarQuery</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;T&gt;&nbsp;type,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;dataMapName,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</code>
<div class="block">Creates a query that selects scalar values and uses routing based on the
provided DataMap name.</div>
</td>
</tr>
<tr id="i36" class="altColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#select-org.apache.cayenne.ObjectContext-">select</a></span>(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</code>
<div class="block">Selects objects using provided context.</div>
</td>
</tr>
<tr id="i37" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#selectFirst-org.apache.cayenne.ObjectContext-">selectFirst</a></span>(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</code>
<div class="block">Selects a single object using provided context.</div>
</td>
</tr>
<tr id="i38" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#selectOne-org.apache.cayenne.ObjectContext-">selectOne</a></span>(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</code>
<div class="block">Selects a single object using provided context.</div>
</td>
</tr>
<tr id="i39" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#sharedCache--">sharedCache</a></span>()</code>
<div class="block">Instructs Cayenne to look for query results in the "shared" cache when
running the query.</div>
</td>
</tr>
<tr id="i40" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#sharedCache-java.lang.String-">sharedCache</a></span>(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</code>
<div class="block">Instructs Cayenne to look for query results in the "shared" cache when
running the query.</div>
</td>
</tr>
<tr id="i41" class="rowColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#statementFetchSize-int-">statementFetchSize</a></span>(int&nbsp;size)</code>
<div class="block">Sets JDBC statement's fetch size (0 for no default size)</div>
</td>
</tr>
<tr id="i42" class="altColor">
<td class="colFirst"><code><a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/cayenne/query/SQLSelect.html#upperColumnNames--">upperColumnNames</a></span>()</code>
<div class="block">Equivalent of setting <a href="../../../../org/apache/cayenne/query/CapsStrategy.html#UPPER"><code>CapsStrategy.UPPER</code></a></div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.org.apache.cayenne.query.IndirectQuery">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;org.apache.cayenne.query.<a href="../../../../org/apache/cayenne/query/IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></h3>
<code><a href="../../../../org/apache/cayenne/query/IndirectQuery.html#createSQLAction-org.apache.cayenne.query.SQLActionVisitor-">createSQLAction</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#getDataMap--">getDataMap</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#getMetaData-org.apache.cayenne.map.EntityResolver-">getMetaData</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#getName--">getName</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#getReplacementQuery-org.apache.cayenne.map.EntityResolver-">getReplacementQuery</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#route-org.apache.cayenne.query.QueryRouter-org.apache.cayenne.map.EntityResolver-org.apache.cayenne.query.Query-">route</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#setDataMap-org.apache.cayenne.map.DataMap-">setDataMap</a>, <a href="../../../../org/apache/cayenne/query/IndirectQuery.html#setName-java.lang.String-">setName</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.java.lang.Object">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></h3>
<code><a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#clone--" title="class or interface in java.lang">clone</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#equals-java.lang.Object-" title="class or interface in java.lang">equals</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#finalize--" title="class or interface in java.lang">finalize</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#getClass--" title="class or interface in java.lang">getClass</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#hashCode--" title="class or interface in java.lang">hashCode</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#notify--" title="class or interface in java.lang">notify</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#notifyAll--" title="class or interface in java.lang">notifyAll</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#toString--" title="class or interface in java.lang">toString</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait--" title="class or interface in java.lang">wait</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait-long-" title="class or interface in java.lang">wait</a>, <a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait-long-int-" title="class or interface in java.lang">wait</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.org.apache.cayenne.query.Query">
<!-- -->
</a>
<h3>Methods inherited from interface&nbsp;org.apache.cayenne.query.<a href="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</a></h3>
<code><a href="../../../../org/apache/cayenne/query/Query.html#createSQLAction-org.apache.cayenne.query.SQLActionVisitor-">createSQLAction</a>, <a href="../../../../org/apache/cayenne/query/Query.html#getDataMap--">getDataMap</a>, <a href="../../../../org/apache/cayenne/query/Query.html#getMetaData-org.apache.cayenne.map.EntityResolver-">getMetaData</a>, <a href="../../../../org/apache/cayenne/query/Query.html#getName--">getName</a>, <a href="../../../../org/apache/cayenne/query/Query.html#route-org.apache.cayenne.query.QueryRouter-org.apache.cayenne.map.EntityResolver-org.apache.cayenne.query.Query-">route</a></code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ============ FIELD DETAIL =========== -->
<ul class="blockList">
<li class="blockList"><a name="field.detail">
<!-- -->
</a>
<h3>Field Detail</h3>
<a name="persistentType">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>persistentType</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt; persistentType</pre>
</li>
</ul>
<a name="scalarType">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>scalarType</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt; scalarType</pre>
</li>
</ul>
<a name="dataMapName">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>dataMapName</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> dataMapName</pre>
</li>
</ul>
<a name="sqlBuffer">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>sqlBuffer</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/StringBuilder.html?is-external=true" title="class or interface in java.lang">StringBuilder</a> sqlBuffer</pre>
</li>
</ul>
<a name="cacheStrategy">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cacheStrategy</h4>
<pre>protected&nbsp;<a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> cacheStrategy</pre>
</li>
</ul>
<a name="cacheGroup">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cacheGroup</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> cacheGroup</pre>
</li>
</ul>
<a name="params">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>params</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>,<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt; params</pre>
</li>
</ul>
<a name="positionalParams">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>positionalParams</h4>
<pre>protected&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt; positionalParams</pre>
</li>
</ul>
<a name="columnNameCaps">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>columnNameCaps</h4>
<pre>protected&nbsp;<a href="../../../../org/apache/cayenne/query/CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a> columnNameCaps</pre>
</li>
</ul>
<a name="limit">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>limit</h4>
<pre>protected&nbsp;int limit</pre>
</li>
</ul>
<a name="offset">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>offset</h4>
<pre>protected&nbsp;int offset</pre>
</li>
</ul>
<a name="pageSize">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>pageSize</h4>
<pre>protected&nbsp;int pageSize</pre>
</li>
</ul>
<a name="statementFetchSize">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>statementFetchSize</h4>
<pre>protected&nbsp;int statementFetchSize</pre>
</li>
</ul>
</li>
</ul>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor.detail">
<!-- -->
</a>
<h3>Constructor Detail</h3>
<a name="SQLSelect-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SQLSelect</h4>
<pre>public&nbsp;SQLSelect(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
</li>
</ul>
<a name="SQLSelect-java.lang.Class-java.lang.String-">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>SQLSelect</h4>
<pre>public&nbsp;SQLSelect(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;persistentType,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method.detail">
<!-- -->
</a>
<h3>Method Detail</h3>
<a name="dataRowQuery-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>dataRowQuery</h4>
<pre>public static&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/DataRow.html" title="class in org.apache.cayenne">DataRow</a>&gt;&nbsp;dataRowQuery(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
<div class="block">Creates a query that selects DataRows and uses default routing.</div>
</li>
</ul>
<a name="dataRowQuery-java.lang.String-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>dataRowQuery</h4>
<pre>public static&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/DataRow.html" title="class in org.apache.cayenne">DataRow</a>&gt;&nbsp;dataRowQuery(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;dataMapName,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
<div class="block">Creates a query that selects DataRows and uses routing based on the
provided DataMap name.</div>
</li>
</ul>
<a name="query-java.lang.Class-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>query</h4>
<pre>public static&nbsp;&lt;T&gt;&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;T&gt;&nbsp;query(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;T&gt;&nbsp;type,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
<div class="block">Creates a query that selects DataObjects.</div>
</li>
</ul>
<a name="scalarQuery-java.lang.Class-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>scalarQuery</h4>
<pre>public static&nbsp;&lt;T&gt;&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;T&gt;&nbsp;scalarQuery(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;T&gt;&nbsp;type,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
<div class="block">Creates a query that selects scalar values and uses default routing.</div>
</li>
</ul>
<a name="scalarQuery-java.lang.Class-java.lang.String-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>scalarQuery</h4>
<pre>public static&nbsp;&lt;T&gt;&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;T&gt;&nbsp;scalarQuery(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</a>&lt;T&gt;&nbsp;type,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;dataMapName,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sql)</pre>
<div class="block">Creates a query that selects scalar values and uses routing based on the
provided DataMap name.</div>
</li>
</ul>
<a name="select-org.apache.cayenne.ObjectContext-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>select</h4>
<pre>public&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;select(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from interface:&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html#select-org.apache.cayenne.ObjectContext-">Select</a></code></span></div>
<div class="block">Selects objects using provided context.
<p>
Essentially the inversion of "ObjectContext.select(Select)".</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/Select.html#select-org.apache.cayenne.ObjectContext-">select</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="selectOne-org.apache.cayenne.ObjectContext-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>selectOne</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&nbsp;selectOne(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from interface:&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html#selectOne-org.apache.cayenne.ObjectContext-">Select</a></code></span></div>
<div class="block">Selects a single object using provided context. The query is expected to
match zero or one object. It returns null if no objects were matched. If
query matched more than one object,
<a href="../../../../org/apache/cayenne/CayenneRuntimeException.html" title="class in org.apache.cayenne"><code>CayenneRuntimeException</code></a> is thrown.
<p>
Essentially the inversion of "ObjectContext.selectOne(Select)".</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/Select.html#selectOne-org.apache.cayenne.ObjectContext-">selectOne</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="selectFirst-org.apache.cayenne.ObjectContext-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>selectFirst</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&nbsp;selectFirst(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from interface:&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html#selectFirst-org.apache.cayenne.ObjectContext-">Select</a></code></span></div>
<div class="block">Selects a single object using provided context. The query itself can
match any number of objects, but will return only the first one. It
returns null if no objects were matched.
<p>
If it matched more than one object, the first object from the list is
returned. This makes 'selectFirst' different from
<a href="../../../../org/apache/cayenne/query/Select.html#selectOne-org.apache.cayenne.ObjectContext-"><code>Select.selectOne(ObjectContext)</code></a>, which would throw in this situation.
'selectFirst' is useful e.g. when the query is ordered and we only want
to see the first object (e.g. "most recent news article"), etc.
<p>
Selecting the first object via "Select.selectFirst(ObjectContext)" is
more comprehensible than selecting via
"ObjectContext.selectFirst(Select)", because implementations of "Select"
set fetch size limit to one.</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/Select.html#selectFirst-org.apache.cayenne.ObjectContext-">selectFirst</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="iterate-org.apache.cayenne.ObjectContext-org.apache.cayenne.ResultIteratorCallback-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>iterate</h4>
<pre>public&nbsp;void&nbsp;iterate(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context,
<a href="../../../../org/apache/cayenne/ResultIteratorCallback.html" title="interface in org.apache.cayenne">ResultIteratorCallback</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;callback)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from interface:&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html#iterate-org.apache.cayenne.ObjectContext-org.apache.cayenne.ResultIteratorCallback-">Select</a></code></span></div>
<div class="block">Creates a ResultIterator based on the provided context and passes it to a
callback for processing. The caller does not need to worry about closing
the iterator. This method takes care of it.
<p>
Essentially the inversion of
"ObjectContext.iterate(Select, ResultIteratorCallback)".</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/Select.html#iterate-org.apache.cayenne.ObjectContext-org.apache.cayenne.ResultIteratorCallback-">iterate</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="iterator-org.apache.cayenne.ObjectContext-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>iterator</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/ResultIterator.html" title="interface in org.apache.cayenne">ResultIterator</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;iterator(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from interface:&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html#iterator-org.apache.cayenne.ObjectContext-">Select</a></code></span></div>
<div class="block">Creates a ResultIterator based on the provided context. It is usually
backed by an open result set and is useful for processing of large data
sets, preserving a constant memory footprint. The caller must wrap
iteration in try/finally (or try-with-resources for Java 1.7 and higher)
and close the ResultIterator explicitly. Or use
<a href="../../../../org/apache/cayenne/query/Select.html#iterate-org.apache.cayenne.ObjectContext-org.apache.cayenne.ResultIteratorCallback-"><code>Select.iterate(ObjectContext, ResultIteratorCallback)</code></a> as an
alternative.
<p>
Essentially the inversion of "ObjectContext.iterator(Select)".</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/Select.html#iterator-org.apache.cayenne.ObjectContext-">iterator</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="batchIterator-org.apache.cayenne.ObjectContext-int-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>batchIterator</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/ResultBatchIterator.html" title="class in org.apache.cayenne">ResultBatchIterator</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;batchIterator(<a href="../../../../org/apache/cayenne/ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a>&nbsp;context,
int&nbsp;size)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from interface:&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html#batchIterator-org.apache.cayenne.ObjectContext-int-">Select</a></code></span></div>
<div class="block">Creates a ResultBatchIterator based on the provided context and batch
size. It is usually backed by an open result set and is useful for
processing of large data sets, preserving a constant memory footprint.
The caller must wrap iteration in try/finally (or try-with-resources for
Java 1.7 and higher) and close the ResultBatchIterator explicitly.</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/Select.html#batchIterator-org.apache.cayenne.ObjectContext-int-">batchIterator</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../org/apache/cayenne/query/Select.html" title="interface in org.apache.cayenne.query">Select</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="isFetchingDataRows--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isFetchingDataRows</h4>
<pre>public&nbsp;boolean&nbsp;isFetchingDataRows()</pre>
</li>
</ul>
<a name="isFetchingScalars--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isFetchingScalars</h4>
<pre>public&nbsp;boolean&nbsp;isFetchingScalars()</pre>
</li>
</ul>
<a name="getSql--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getSql</h4>
<pre>public&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;getSql()</pre>
</li>
</ul>
<a name="append-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>append</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;append(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;sqlChunk)</pre>
<div class="block">Appends a piece of SQL to the previously stored SQL template.</div>
</li>
</ul>
<a name="params-java.lang.String-java.lang.Object-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>params</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;params(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;name,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&nbsp;value)</pre>
</li>
</ul>
<a name="params-java.util.Map-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>params</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;params(<a href="https://docs.oracle.com/javase/7/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>,?&gt;&nbsp;parameters)</pre>
</li>
</ul>
<a name="paramsArray-java.lang.Object...-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>paramsArray</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;paramsArray(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>...&nbsp;params)</pre>
<div class="block">Initializes positional parameters of the query. Parameters are bound in
the order they are found in the SQL template. If a given parameter name
is used more than once, only the first occurrence is treated as
"position", subsequent occurrences are bound with the same value as the
first one. If template parameters count is different from the array
parameter count, an exception will be thrown.
<p>
Note that calling this method will reset any previously set *named*
parameters.</div>
</li>
</ul>
<a name="paramsList-java.util.List-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>paramsList</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;paramsList(<a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;&nbsp;params)</pre>
<div class="block">Initializes positional parameters of the query. Parameters are bound in
the order they are found in the SQL template. If a given parameter name
is used more than once, only the first occurrence is treated as
"position", subsequent occurrences are bound with the same value as the
first one. If template parameters count is different from the list
parameter count, an exception will be thrown.
<p>
Note that calling this method will reset any previously set *named*
parameters.</div>
</li>
</ul>
<a name="getParams--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getParams</h4>
<pre>public&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>,<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;&nbsp;getParams()</pre>
<div class="block">Returns a potentially immmutable map of named parameters that will be
bound to SQL.</div>
</li>
</ul>
<a name="getPositionalParams--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getPositionalParams</h4>
<pre>public&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a>&lt;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>&gt;&nbsp;getPositionalParams()</pre>
<div class="block">Returns a potentially immmutable list of positional parameters that will
be bound to SQL.</div>
</li>
</ul>
<a name="createReplacementQuery-org.apache.cayenne.map.EntityResolver-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createReplacementQuery</h4>
<pre>protected&nbsp;<a href="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</a>&nbsp;createReplacementQuery(<a href="../../../../org/apache/cayenne/map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a>&nbsp;resolver)</pre>
<div class="block"><span class="descfrmTypeLabel">Description copied from class:&nbsp;<code><a href="../../../../org/apache/cayenne/query/IndirectQuery.html#createReplacementQuery-org.apache.cayenne.map.EntityResolver-">IndirectQuery</a></code></span></div>
<div class="block">Creates a substitute query. An implementor is free to provide an
arbitrary replacement query.</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="../../../../org/apache/cayenne/query/IndirectQuery.html#createReplacementQuery-org.apache.cayenne.map.EntityResolver-">createReplacementQuery</a></code>&nbsp;in class&nbsp;<code><a href="../../../../org/apache/cayenne/query/IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></code></dd>
</dl>
</li>
</ul>
<a name="localCache--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>localCache</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;localCache()</pre>
<div class="block">Instructs Cayenne to look for query results in the "local" cache when
running the query. This is a short-hand notation for:
<pre>
query.cacheStrategy(QueryCacheStrategy.LOCAL_CACHE);
</pre></div>
</li>
</ul>
<a name="localCache-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>localCache</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;localCache(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</pre>
<div class="block">Instructs Cayenne to look for query results in the "local" cache when
running the query. This is a short-hand notation for:
<pre>
query.cacheStrategy(QueryCacheStrategy.LOCAL_CACHE, cacheGroup);
</pre></div>
</li>
</ul>
<a name="sharedCache--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>sharedCache</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;sharedCache()</pre>
<div class="block">Instructs Cayenne to look for query results in the "shared" cache when
running the query. This is a short-hand notation for:
<pre>
query.cacheStrategy(QueryCacheStrategy.SHARED_CACHE);
</pre></div>
</li>
</ul>
<a name="sharedCache-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>sharedCache</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;sharedCache(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</pre>
<div class="block">Instructs Cayenne to look for query results in the "shared" cache when
running the query. This is a short-hand notation for:
<pre>
query.cacheStrategy(QueryCacheStrategy.SHARED_CACHE, cacheGroup);
</pre></div>
</li>
</ul>
<a name="getCacheStrategy--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCacheStrategy</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a>&nbsp;getCacheStrategy()</pre>
</li>
</ul>
<a name="cacheStrategy-org.apache.cayenne.query.QueryCacheStrategy-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cacheStrategy</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;cacheStrategy(<a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a>&nbsp;strategy)</pre>
</li>
</ul>
<a name="cacheStrategy-org.apache.cayenne.query.QueryCacheStrategy-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cacheStrategy</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;cacheStrategy(<a href="../../../../org/apache/cayenne/query/QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a>&nbsp;strategy,
<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</pre>
</li>
</ul>
<a name="getCacheGroup--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCacheGroup</h4>
<pre>public&nbsp;<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;getCacheGroup()</pre>
</li>
</ul>
<a name="cacheGroup-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cacheGroup</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;cacheGroup(<a href="https://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;cacheGroup)</pre>
</li>
</ul>
<a name="getColumnNameCaps--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnNameCaps</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a>&nbsp;getColumnNameCaps()</pre>
<div class="block">Returns a column name capitalization policy applied to selecting queries.
This is used to simplify mapping of the queries like "SELECT * FROM ...",
ensuring that a chosen Cayenne column mapping strategy (e.g. all column
names in uppercase) is portable across database engines that can have
varying default capitalization. Default (null) value indicates that
column names provided in result set are used unchanged.</div>
</li>
</ul>
<a name="columnNameCaps-org.apache.cayenne.query.CapsStrategy-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>columnNameCaps</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;columnNameCaps(<a href="../../../../org/apache/cayenne/query/CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a>&nbsp;columnNameCaps)</pre>
<div class="block">Sets a column name capitalization policy applied to selecting queries.
This is used to simplify mapping of the queries like "SELECT * FROM ...",
ensuring that a chosen Cayenne column mapping strategy (e.g. all column
names in uppercase) is portable across database engines that can have
varying default capitalization. Default (null) value indicates that
column names provided in result set are used unchanged.
<p>
Note that while a non-default setting is useful for queries that do not
rely on a #result directive to describe columns, it works for all
SQLTemplates the same way.</div>
</li>
</ul>
<a name="upperColumnNames--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>upperColumnNames</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;upperColumnNames()</pre>
<div class="block">Equivalent of setting <a href="../../../../org/apache/cayenne/query/CapsStrategy.html#UPPER"><code>CapsStrategy.UPPER</code></a></div>
</li>
</ul>
<a name="lowerColumnNames--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lowerColumnNames</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;lowerColumnNames()</pre>
<div class="block">Equivalent of setting <a href="../../../../org/apache/cayenne/query/CapsStrategy.html#LOWER"><code>CapsStrategy.LOWER</code></a></div>
</li>
</ul>
<a name="getLimit--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLimit</h4>
<pre>public&nbsp;int&nbsp;getLimit()</pre>
</li>
</ul>
<a name="limit-int-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>limit</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;limit(int&nbsp;fetchLimit)</pre>
</li>
</ul>
<a name="getOffset--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getOffset</h4>
<pre>public&nbsp;int&nbsp;getOffset()</pre>
</li>
</ul>
<a name="offset-int-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>offset</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;offset(int&nbsp;fetchOffset)</pre>
</li>
</ul>
<a name="getPageSize--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getPageSize</h4>
<pre>public&nbsp;int&nbsp;getPageSize()</pre>
</li>
</ul>
<a name="pageSize-int-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>pageSize</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;pageSize(int&nbsp;pageSize)</pre>
</li>
</ul>
<a name="statementFetchSize-int-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>statementFetchSize</h4>
<pre>public&nbsp;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a>&lt;<a href="../../../../org/apache/cayenne/query/SQLSelect.html" title="type parameter in SQLSelect">T</a>&gt;&nbsp;statementFetchSize(int&nbsp;size)</pre>
<div class="block">Sets JDBC statement's fetch size (0 for no default size)</div>
</li>
</ul>
<a name="getStatementFetchSize--">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>getStatementFetchSize</h4>
<pre>public&nbsp;int&nbsp;getStatementFetchSize()</pre>
<dl>
<dt><span class="returnLabel">Returns:</span></dt>
<dd>JBDC statement's fetch size</dd>
</dl>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar.bottom">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div>
<a name="navbar.bottom.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/SQLSelect.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../index-all.html">Index</a></li>
<li><a href="../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../org/apache/cayenne/query/SQLExec.html" title="class in org.apache.cayenne.query"><span class="typeNameLink">Prev&nbsp;Class</span></a></li>
<li><a href="../../../../org/apache/cayenne/query/SQLTemplate.html" title="class in org.apache.cayenne.query"><span class="typeNameLink">Next&nbsp;Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../index.html?org/apache/cayenne/query/SQLSelect.html" target="_top">Frames</a></li>
<li><a href="SQLSelect.html" target="_top">No&nbsp;Frames</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../allclasses-noframe.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_bottom");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&nbsp;|&nbsp;</li>
<li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a name="skip.navbar.bottom">
<!-- -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>Copyright &#169; 2001&#x2013;2019 <a href="http://cayenne.apache.org/">Apache Cayenne</a>. All rights reserved.</small></p>
</body>
</html>