| <!DOCTYPE HTML> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (11.0.2) on Mon Mar 18 14:01:21 MSK 2019 --> |
| <title>SQLSelect (cayenne-doc: Cayenne Documentation 4.1.B1 API)</title> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <meta name="dc.created" content="2019-03-18"> |
| <link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style"> |
| <link rel="stylesheet" type="text/css" href="../../../../jquery/jquery-ui.css" title="Style"> |
| <script type="text/javascript" src="../../../../script.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jszip/dist/jszip.min.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script> |
| <!--[if IE]> |
| <script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script> |
| <![endif]--> |
| <script type="text/javascript" src="../../../../jquery/jquery-3.3.1.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jquery-migrate-3.0.1.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jquery-ui.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.1.B1 API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var data = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"i7":10,"i8":10,"i9":9,"i10":9,"i11":9,"i12":9,"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":10,"i34":10,"i35":10,"i36":9,"i37":9,"i38":9,"i39":9,"i40":9,"i41":9,"i42":9,"i43":9,"i44":9,"i45":10,"i46":10,"i47":10,"i48":10,"i49":10,"i50":10,"i51":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"; |
| var pathtoroot = "../../../../"; |
| var useModuleDirectories = true; |
| loadScripts(document, 'script');</script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <header role="banner"> |
| <nav role="navigation"> |
| <div class="fixedNav"> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a id="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../index.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 class="aboutLanguage"><a href="http://cayenne.apache.org" target="top">Apache Cayenne</a></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../allclasses.html">All Classes</a></li> |
| </ul> |
| <ul class="navListSearch"> |
| <li><label for="search">SEARCH:</label> |
| <input type="text" id="search" value="search" disabled="disabled"> |
| <input type="reset" id="reset" value="reset" disabled="disabled"> |
| </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> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a id="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| </div> |
| <div class="navPadding"> </div> |
| <script type="text/javascript"><!-- |
| $('.navPadding').css('padding-top', $('.fixedNav').css("height")); |
| //--> |
| </script> |
| </nav> |
| </header> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <main role="main"> |
| <div class="header"> |
| <div class="subTitle"><span class="packageLabelInType">Package</span> <a href="package-summary.html">org.apache.cayenne.query</a></div> |
| <h2 title="Class SQLSelect" class="title">Class SQLSelect<T></h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">java.lang.Object</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="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<T></li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <dl> |
| <dt>All Implemented Interfaces:</dt> |
| <dd><code><a href="https://docs.oracle.com/javase/8/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io" class="externalLink">Serializable</a></code>, <code><a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code>, <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><T></code></dd> |
| </dl> |
| <hr> |
| <pre>public class <span class="typeNameLabel">SQLSelect<T></span> |
| extends <a href="IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a> |
| implements <a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><T></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 =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Fields</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Field</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheGroup">cacheGroup</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected <a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheStrategy">cacheStrategy</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected <a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#columnNameCaps">columnNameCaps</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dataMapName">dataMapName</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#limit">limit</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#offset">offset</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#pageSize">pageSize</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util" class="externalLink">Map</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>,​<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#params">params</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#persistentType">persistentType</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#positionalParams">positionalParams</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected <a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#prefetches">prefetches</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/StringBuilder.html?is-external=true" title="class or interface in java.lang" class="externalLink">StringBuilder</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sqlBuffer">sqlBuffer</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#statementFetchSize">statementFetchSize</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a id="fields.inherited.from.class.org.apache.cayenne.query.IndirectQuery"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.cayenne.query.<a href="IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></h3> |
| <code><a href="IndirectQuery.html#dataMap">dataMap</a>, <a href="IndirectQuery.html#lastResolver">lastResolver</a>, <a href="IndirectQuery.html#name">name</a>, <a href="IndirectQuery.html#replacementQuery">replacementQuery</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.summary"> |
| <!-- --> |
| </a> |
| <h3>Constructor Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Constructors</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Constructor</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.Class,java.lang.String)">SQLSelect</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> persistentType, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.String)">SQLSelect</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| </section> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <table class="memberSummary"> |
| <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Method</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#addPrefetch(java.lang.String,int)">addPrefetch</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> path, |
| int semantics)</code></th> |
| <td class="colLast"> |
| <div class="block">Merges a prefetch path with specified semantics into the query prefetch tree.</div> |
| </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#addPrefetch(org.apache.cayenne.query.PrefetchTreeNode)">addPrefetch</a></span>​(<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a> node)</code></th> |
| <td class="colLast"> |
| <div class="block">Merges a prefetch into the query prefetch tree.</div> |
| </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#append(java.lang.String)">append</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sqlChunk)</code></th> |
| <td class="colLast"> |
| <div class="block">Appends a piece of SQL to the previously stored SQL template.</div> |
| </td> |
| </tr> |
| <tr id="i3" class="rowColor"> |
| <td class="colFirst"><code><a href="../ResultBatchIterator.html" title="class in org.apache.cayenne">ResultBatchIterator</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#batchIterator(org.apache.cayenne.ObjectContext,int)">batchIterator</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context, |
| int size)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a ResultBatchIterator based on the provided context and batch |
| size.</div> |
| </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheGroup(java.lang.String)">cacheGroup</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i5" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy)">cacheStrategy</a></span>​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i6" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy,java.lang.String)">cacheStrategy</a></span>​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i7" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#columnNameCaps(org.apache.cayenne.query.CapsStrategy)">columnNameCaps</a></span>​(<a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a> columnNameCaps)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets a column name capitalization policy applied to selecting queries.</div> |
| </td> |
| </tr> |
| <tr id="i8" class="altColor"> |
| <td class="colFirst"><code>protected <a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#createReplacementQuery(org.apache.cayenne.map.EntityResolver)">createReplacementQuery</a></span>​(<a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a> resolver)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a substitute query.</div> |
| </td> |
| </tr> |
| <tr id="i9" class="rowColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dataRowQuery(java.lang.String)">dataRowQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects DataRows and uses default routing.</div> |
| </td> |
| </tr> |
| <tr id="i10" class="altColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dataRowQuery(java.lang.String,java.lang.Class...)">dataRowQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects DataRows and uses default routing.</div> |
| </td> |
| </tr> |
| <tr id="i11" class="rowColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dataRowQuery(java.lang.String,java.lang.String)">dataRowQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects DataRows and uses routing based on the |
| provided DataMap name.</div> |
| </td> |
| </tr> |
| <tr id="i12" class="altColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dataRowQuery(java.lang.String,java.lang.String,java.lang.Class...)">dataRowQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects DataRows and uses routing based on the |
| provided DataMap name.</div> |
| </td> |
| </tr> |
| <tr id="i13" class="rowColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getCacheGroup()">getCacheGroup</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i14" class="altColor"> |
| <td class="colFirst"><code><a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getCacheStrategy()">getCacheStrategy</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i15" class="rowColor"> |
| <td class="colFirst"><code><a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getColumnNameCaps()">getColumnNameCaps</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns a column name capitalization policy applied to selecting queries.</div> |
| </td> |
| </tr> |
| <tr id="i16" class="altColor"> |
| <td class="colFirst"><code>int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getLimit()">getLimit</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i17" class="rowColor"> |
| <td class="colFirst"><code>int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getOffset()">getOffset</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i18" class="altColor"> |
| <td class="colFirst"><code>int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getPageSize()">getPageSize</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i19" class="rowColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util" class="externalLink">Map</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>,​<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getParams()">getParams</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns a potentially immmutable map of named parameters that will be |
| bound to SQL.</div> |
| </td> |
| </tr> |
| <tr id="i20" class="altColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getPositionalParams()">getPositionalParams</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns a potentially immmutable list of positional parameters that will |
| be bound to SQL.</div> |
| </td> |
| </tr> |
| <tr id="i21" class="rowColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getSql()">getSql</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i22" class="altColor"> |
| <td class="colFirst"><code>int</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getStatementFetchSize()">getStatementFetchSize</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i23" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isFetchingDataRows()">isFetchingDataRows</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i24" class="altColor"> |
| <td class="colFirst"><code>void</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#iterate(org.apache.cayenne.ObjectContext,org.apache.cayenne.ResultIteratorCallback)">iterate</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context, |
| <a href="../ResultIteratorCallback.html" title="interface in org.apache.cayenne">ResultIteratorCallback</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> callback)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a ResultIterator based on the provided context and passes it to a |
| callback for processing.</div> |
| </td> |
| </tr> |
| <tr id="i25" class="rowColor"> |
| <td class="colFirst"><code><a href="../ResultIterator.html" title="interface in org.apache.cayenne">ResultIterator</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#iterator(org.apache.cayenne.ObjectContext)">iterator</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a ResultIterator based on the provided context.</div> |
| </td> |
| </tr> |
| <tr id="i26" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#limit(int)">limit</a></span>​(int fetchLimit)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i27" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#localCache()">localCache</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "local" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i28" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#localCache(java.lang.String)">localCache</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "local" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i29" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lowerColumnNames()">lowerColumnNames</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Equivalent of setting <a href="CapsStrategy.html#LOWER"><code>CapsStrategy.LOWER</code></a></div> |
| </td> |
| </tr> |
| <tr id="i30" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#offset(int)">offset</a></span>​(int fetchOffset)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i31" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#pageSize(int)">pageSize</a></span>​(int pageSize)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i32" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#params(java.lang.String,java.lang.Object)">params</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> name, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a> value)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i33" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#params(java.util.Map)">params</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util" class="externalLink">Map</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>,​?> parameters)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i34" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#paramsArray(java.lang.Object...)">paramsArray</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>... params)</code></th> |
| <td class="colLast"> |
| <div class="block">Initializes positional parameters of the query.</div> |
| </td> |
| </tr> |
| <tr id="i35" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#paramsList(java.util.List)">paramsList</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>> params)</code></th> |
| <td class="colLast"> |
| <div class="block">Initializes positional parameters of the query.</div> |
| </td> |
| </tr> |
| <tr id="i36" class="altColor"> |
| <td class="colFirst"><code>static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#query(java.lang.Class,java.lang.String)">query</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects DataObjects.</div> |
| </td> |
| </tr> |
| <tr id="i37" class="rowColor"> |
| <td class="colFirst"><code>static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.Class,java.lang.String)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects scalar values and uses default routing.</div> |
| </td> |
| </tr> |
| <tr id="i38" class="altColor"> |
| <td class="colFirst"><code>static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.Class,java.lang.String,java.lang.String)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates a query that selects scalar values and uses routing based on the |
| provided DataMap name.</div> |
| </td> |
| </tr> |
| <tr id="i39" class="rowColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.String)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates query that selects scalar value and uses default routing</div> |
| </td> |
| </tr> |
| <tr id="i40" class="altColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.String,java.lang.Class,java.lang.Class...)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?> firstType, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates query that selects scalar values (as Object[]) and uses default routing</div> |
| </td> |
| </tr> |
| <tr id="i41" class="rowColor"> |
| <td class="colFirst"><code>static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.String,java.lang.Class)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates query that selects scalar value and uses default routing</div> |
| </td> |
| </tr> |
| <tr id="i42" class="altColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.String,java.lang.String)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates query that selects scalar values (as Object[]) and uses routing based on the |
| provided DataMap name.</div> |
| </td> |
| </tr> |
| <tr id="i43" class="rowColor"> |
| <td class="colFirst"><code>static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.String,java.lang.String,java.lang.Class,java.lang.Class...)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?> firstType, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates query that selects scalar values (as Object[]) and uses routing based on the |
| provided DataMap name.</div> |
| </td> |
| </tr> |
| <tr id="i44" class="altColor"> |
| <td class="colFirst"><code>static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#scalarQuery(java.lang.String,java.lang.String,java.lang.Class)">scalarQuery</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type)</code></th> |
| <td class="colLast"> |
| <div class="block">Creates query that selects scalar value and uses default routing</div> |
| </td> |
| </tr> |
| <tr id="i45" class="rowColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#select(org.apache.cayenne.ObjectContext)">select</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</code></th> |
| <td class="colLast"> |
| <div class="block">Selects objects using provided context.</div> |
| </td> |
| </tr> |
| <tr id="i46" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="type parameter in SQLSelect">T</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#selectFirst(org.apache.cayenne.ObjectContext)">selectFirst</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</code></th> |
| <td class="colLast"> |
| <div class="block">Selects a single object using provided context.</div> |
| </td> |
| </tr> |
| <tr id="i47" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="type parameter in SQLSelect">T</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#selectOne(org.apache.cayenne.ObjectContext)">selectOne</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</code></th> |
| <td class="colLast"> |
| <div class="block">Selects a single object using provided context.</div> |
| </td> |
| </tr> |
| <tr id="i48" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sharedCache()">sharedCache</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "shared" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i49" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sharedCache(java.lang.String)">sharedCache</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "shared" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i50" class="altColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#statementFetchSize(int)">statementFetchSize</a></span>​(int size)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets JDBC statement's fetch size (0 for no default size)</div> |
| </td> |
| </tr> |
| <tr id="i51" class="rowColor"> |
| <td class="colFirst"><code><a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#upperColumnNames()">upperColumnNames</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Equivalent of setting <a href="CapsStrategy.html#UPPER"><code>CapsStrategy.UPPER</code></a></div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.IndirectQuery"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.cayenne.query.<a href="IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></h3> |
| <code><a href="IndirectQuery.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a>, <a href="IndirectQuery.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a>, <a href="IndirectQuery.html#getReplacementQuery(org.apache.cayenne.map.EntityResolver)">getReplacementQuery</a>, <a href="IndirectQuery.html#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">route</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a></h3> |
| <code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#clone()" title="class or interface in java.lang" class="externalLink">clone</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#equals(java.lang.Object)" title="class or interface in java.lang" class="externalLink">equals</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#finalize()" title="class or interface in java.lang" class="externalLink">finalize</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#getClass()" title="class or interface in java.lang" class="externalLink">getClass</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#hashCode()" title="class or interface in java.lang" class="externalLink">hashCode</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notify()" title="class or interface in java.lang" class="externalLink">notify</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notifyAll()" title="class or interface in java.lang" class="externalLink">notifyAll</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#toString()" title="class or interface in java.lang" class="externalLink">toString</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait()" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait(long)" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait(long,int)" title="class or interface in java.lang" class="externalLink">wait</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.Query"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from interface org.apache.cayenne.query.<a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></h3> |
| <code><a href="Query.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a>, <a href="Query.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a>, <a href="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> |
| </section> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ============ FIELD DETAIL =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.detail"> |
| <!-- --> |
| </a> |
| <h3>Field Detail</h3> |
| <a id="persistentType"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>persistentType</h4> |
| <pre>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> persistentType</pre> |
| </li> |
| </ul> |
| <a id="dataMapName"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dataMapName</h4> |
| <pre>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName</pre> |
| </li> |
| </ul> |
| <a id="sqlBuffer"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sqlBuffer</h4> |
| <pre>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/StringBuilder.html?is-external=true" title="class or interface in java.lang" class="externalLink">StringBuilder</a> sqlBuffer</pre> |
| </li> |
| </ul> |
| <a id="cacheStrategy"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheStrategy</h4> |
| <pre>protected <a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> cacheStrategy</pre> |
| </li> |
| </ul> |
| <a id="cacheGroup"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheGroup</h4> |
| <pre>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup</pre> |
| </li> |
| </ul> |
| <a id="params"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>params</h4> |
| <pre>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util" class="externalLink">Map</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>,​<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>> params</pre> |
| </li> |
| </ul> |
| <a id="positionalParams"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>positionalParams</h4> |
| <pre>protected <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>> positionalParams</pre> |
| </li> |
| </ul> |
| <a id="columnNameCaps"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>columnNameCaps</h4> |
| <pre>protected <a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a> columnNameCaps</pre> |
| </li> |
| </ul> |
| <a id="limit"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>limit</h4> |
| <pre>protected int limit</pre> |
| </li> |
| </ul> |
| <a id="offset"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>offset</h4> |
| <pre>protected int offset</pre> |
| </li> |
| </ul> |
| <a id="pageSize"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>pageSize</h4> |
| <pre>protected int pageSize</pre> |
| </li> |
| </ul> |
| <a id="statementFetchSize"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>statementFetchSize</h4> |
| <pre>protected int statementFetchSize</pre> |
| </li> |
| </ul> |
| <a id="prefetches"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>prefetches</h4> |
| <pre>protected <a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a> prefetches</pre> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.detail"> |
| <!-- --> |
| </a> |
| <h3>Constructor Detail</h3> |
| <a id="<init>(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SQLSelect</h4> |
| <pre>public SQLSelect​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| </li> |
| </ul> |
| <a id="<init>(java.lang.Class,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>SQLSelect</h4> |
| <pre>public SQLSelect​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> persistentType, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ============ METHOD DETAIL ========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a id="dataRowQuery(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dataRowQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>> dataRowQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| <div class="block">Creates a query that selects DataRows and uses default routing.</div> |
| </li> |
| </ul> |
| <a id="dataRowQuery(java.lang.String,java.lang.Class...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dataRowQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>> dataRowQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</pre> |
| <div class="block">Creates a query that selects DataRows and uses default routing.</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="dataRowQuery(java.lang.String,java.lang.String,java.lang.Class...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dataRowQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>> dataRowQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</pre> |
| <div class="block">Creates a query that selects DataRows and uses routing based on the |
| provided DataMap name.</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="dataRowQuery(java.lang.String,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dataRowQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="../DataRow.html" title="class in org.apache.cayenne">DataRow</a>> dataRowQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| <div class="block">Creates a query that selects DataRows and uses routing based on the |
| provided DataMap name.</div> |
| </li> |
| </ul> |
| <a id="query(java.lang.Class,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>query</h4> |
| <pre class="methodSignature">public static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T> query​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| <div class="block">Creates a query that selects DataObjects.</div> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.Class,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| <div class="block">Creates a query that selects scalar values and uses default routing.</div> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.Class,java.lang.String,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> 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 id="scalarQuery(java.lang.String,java.lang.Class)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type)</pre> |
| <div class="block">Creates query that selects scalar value and uses default routing</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.String,java.lang.String,java.lang.Class)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <T> <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><T> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><T> type)</pre> |
| <div class="block">Creates query that selects scalar value and uses default routing</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql)</pre> |
| <div class="block">Creates query that selects scalar value and uses default routing</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.String,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName)</pre> |
| <div class="block">Creates query that selects scalar values (as Object[]) and uses routing based on the |
| provided DataMap name.</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.String,java.lang.Class,java.lang.Class...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?> firstType, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</pre> |
| <div class="block">Creates query that selects scalar values (as Object[]) and uses default routing</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="scalarQuery(java.lang.String,java.lang.String,java.lang.Class,java.lang.Class...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>scalarQuery</h4> |
| <pre class="methodSignature">public static <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> scalarQuery​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dataMapName, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?> firstType, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?>... types)</pre> |
| <div class="block">Creates query that selects scalar values (as Object[]) and uses routing based on the |
| provided DataMap name.</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="select(org.apache.cayenne.ObjectContext)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>select</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> select​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="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="Select.html#select(org.apache.cayenne.ObjectContext)">select</a></code> in interface <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="selectOne(org.apache.cayenne.ObjectContext)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>selectOne</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="type parameter in SQLSelect">T</a> selectOne​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="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="../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="Select.html#selectOne(org.apache.cayenne.ObjectContext)">selectOne</a></code> in interface <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="selectFirst(org.apache.cayenne.ObjectContext)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>selectFirst</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="type parameter in SQLSelect">T</a> selectFirst​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="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="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="Select.html#selectFirst(org.apache.cayenne.ObjectContext)">selectFirst</a></code> in interface <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="iterate(org.apache.cayenne.ObjectContext,org.apache.cayenne.ResultIteratorCallback)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>iterate</h4> |
| <pre class="methodSignature">public void iterate​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context, |
| <a href="../ResultIteratorCallback.html" title="interface in org.apache.cayenne">ResultIteratorCallback</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> callback)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="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="Select.html#iterate(org.apache.cayenne.ObjectContext,org.apache.cayenne.ResultIteratorCallback)">iterate</a></code> in interface <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="iterator(org.apache.cayenne.ObjectContext)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>iterator</h4> |
| <pre class="methodSignature">public <a href="../ResultIterator.html" title="interface in org.apache.cayenne">ResultIterator</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> iterator​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="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="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="Select.html#iterator(org.apache.cayenne.ObjectContext)">iterator</a></code> in interface <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="batchIterator(org.apache.cayenne.ObjectContext,int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>batchIterator</h4> |
| <pre class="methodSignature">public <a href="../ResultBatchIterator.html" title="class in org.apache.cayenne">ResultBatchIterator</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> batchIterator​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context, |
| int size)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="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="Select.html#batchIterator(org.apache.cayenne.ObjectContext,int)">batchIterator</a></code> in interface <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="isFetchingDataRows()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isFetchingDataRows</h4> |
| <pre class="methodSignature">public boolean isFetchingDataRows()</pre> |
| </li> |
| </ul> |
| <a id="getSql()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getSql</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> getSql()</pre> |
| </li> |
| </ul> |
| <a id="append(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>append</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> append​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sqlChunk)</pre> |
| <div class="block">Appends a piece of SQL to the previously stored SQL template.</div> |
| </li> |
| </ul> |
| <a id="params(java.lang.String,java.lang.Object)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>params</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> params​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> name, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a> value)</pre> |
| </li> |
| </ul> |
| <a id="params(java.util.Map)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>params</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> params​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util" class="externalLink">Map</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>,​?> parameters)</pre> |
| </li> |
| </ul> |
| <a id="paramsArray(java.lang.Object...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>paramsArray</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> paramsArray​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>... 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 id="paramsList(java.util.List)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>paramsList</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> paramsList​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>> 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 id="getParams()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getParams</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util" class="externalLink">Map</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>,​<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>> getParams()</pre> |
| <div class="block">Returns a potentially immmutable map of named parameters that will be |
| bound to SQL.</div> |
| </li> |
| </ul> |
| <a id="getPositionalParams()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getPositionalParams</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>> getPositionalParams()</pre> |
| <div class="block">Returns a potentially immmutable list of positional parameters that will |
| be bound to SQL.</div> |
| </li> |
| </ul> |
| <a id="createReplacementQuery(org.apache.cayenne.map.EntityResolver)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createReplacementQuery</h4> |
| <pre class="methodSignature">protected <a href="Query.html" title="interface in org.apache.cayenne.query">Query</a> createReplacementQuery​(<a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a> resolver)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="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="IndirectQuery.html#createReplacementQuery(org.apache.cayenne.map.EntityResolver)">createReplacementQuery</a></code> in class <code><a href="IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="localCache()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>localCache</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> 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 id="localCache(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>localCache</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> localCache​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> 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 id="sharedCache()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sharedCache</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> 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 id="sharedCache(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sharedCache</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> sharedCache​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> 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 id="getCacheStrategy()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getCacheStrategy</h4> |
| <pre class="methodSignature">public <a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> getCacheStrategy()</pre> |
| </li> |
| </ul> |
| <a id="cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheStrategy</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> cacheStrategy​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy)</pre> |
| </li> |
| </ul> |
| <a id="cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheStrategy</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> cacheStrategy​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</pre> |
| </li> |
| </ul> |
| <a id="getCacheGroup()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getCacheGroup</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> getCacheGroup()</pre> |
| </li> |
| </ul> |
| <a id="cacheGroup(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheGroup</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> cacheGroup​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</pre> |
| </li> |
| </ul> |
| <a id="getColumnNameCaps()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getColumnNameCaps</h4> |
| <pre class="methodSignature">public <a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a> 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 id="columnNameCaps(org.apache.cayenne.query.CapsStrategy)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>columnNameCaps</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> columnNameCaps​(<a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a> 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 id="upperColumnNames()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>upperColumnNames</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> upperColumnNames()</pre> |
| <div class="block">Equivalent of setting <a href="CapsStrategy.html#UPPER"><code>CapsStrategy.UPPER</code></a></div> |
| </li> |
| </ul> |
| <a id="lowerColumnNames()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>lowerColumnNames</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> lowerColumnNames()</pre> |
| <div class="block">Equivalent of setting <a href="CapsStrategy.html#LOWER"><code>CapsStrategy.LOWER</code></a></div> |
| </li> |
| </ul> |
| <a id="getLimit()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getLimit</h4> |
| <pre class="methodSignature">public int getLimit()</pre> |
| </li> |
| </ul> |
| <a id="limit(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>limit</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> limit​(int fetchLimit)</pre> |
| </li> |
| </ul> |
| <a id="getOffset()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getOffset</h4> |
| <pre class="methodSignature">public int getOffset()</pre> |
| </li> |
| </ul> |
| <a id="offset(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>offset</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> offset​(int fetchOffset)</pre> |
| </li> |
| </ul> |
| <a id="getPageSize()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getPageSize</h4> |
| <pre class="methodSignature">public int getPageSize()</pre> |
| </li> |
| </ul> |
| <a id="pageSize(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>pageSize</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> pageSize​(int pageSize)</pre> |
| </li> |
| </ul> |
| <a id="statementFetchSize(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>statementFetchSize</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> statementFetchSize​(int size)</pre> |
| <div class="block">Sets JDBC statement's fetch size (0 for no default size)</div> |
| </li> |
| </ul> |
| <a id="getStatementFetchSize()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getStatementFetchSize</h4> |
| <pre class="methodSignature">public int getStatementFetchSize()</pre> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>JBDC statement's fetch size</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="addPrefetch(java.lang.String,int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>addPrefetch</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> addPrefetch​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> path, |
| int semantics)</pre> |
| <div class="block">Merges a prefetch path with specified semantics into the query prefetch tree.</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>path</code> - Path expression</dd> |
| <dd><code>semantics</code> - Defines a strategy to prefetch relationships. See <a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query"><code>PrefetchTreeNode</code></a></dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="addPrefetch(org.apache.cayenne.query.PrefetchTreeNode)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>addPrefetch</h4> |
| <pre class="methodSignature">public <a href="SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><<a href="SQLSelect.html" title="type parameter in SQLSelect">T</a>> addPrefetch​(<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a> node)</pre> |
| <div class="block">Merges a prefetch into the query prefetch tree.</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>node</code> - Prefetch which will added to query prefetch tree</dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </main> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <footer role="contentinfo"> |
| <nav role="navigation"> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a id="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../index.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 class="aboutLanguage"><a href="http://cayenne.apache.org" target="top">Apache Cayenne</a></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../allclasses.html">All 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> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a id="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| </nav> |
| <p class="legalCopy"><small>Copyright © 2001–2019 <a href="http://cayenne.apache.org/">Apache Cayenne</a>. All rights reserved.</small></p> |
| </footer> |
| </body> |
| </html> |