| <!DOCTYPE HTML> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (11.0.10) on Mon Dec 05 10:27:04 MSK 2022 --> |
| <title>Uses of Class org.apache.cayenne.query.SQLSelect (cayenne-doc: Cayenne Documentation 4.2.RC2 API)</title> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <meta name="dc.created" content="2022-12-05"> |
| <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.5.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="Uses of Class org.apache.cayenne.query.SQLSelect (cayenne-doc: Cayenne Documentation 4.2.RC2 API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var pathtoroot = "../../../../../"; |
| var useModuleDirectories = false; |
| 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><a href="../SQLSelect.html" title="class in org.apache.cayenne.query">Class</a></li> |
| <li class="navBarCell1Rev">Use</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> |
| <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> |
| <main role="main"> |
| <div class="header"> |
| <h2 title="Uses of Class org.apache.cayenne.query.SQLSelect" class="title">Uses of Class<br>org.apache.cayenne.query.SQLSelect</h2> |
| </div> |
| <div class="classUseContainer"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <table class="useSummary"> |
| <caption><span>Packages that use <a href="../SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a></span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Package</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tbody> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><a href="#org.apache.cayenne.query">org.apache.cayenne.query</a></th> |
| <td class="colLast"> |
| <div class="block">Defines standard queries supported by Cayenne and extension mechanism to create |
| custom queries.</div> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| </li> |
| <li class="blockList"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <section role="region"><a id="org.apache.cayenne.query"> |
| <!-- --> |
| </a> |
| <h3>Uses of <a href="../SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a> in <a href="../package-summary.html">org.apache.cayenne.query</a></h3> |
| <table class="useSummary"> |
| <caption><span>Methods in <a href="../package-summary.html">org.apache.cayenne.query</a> that return <a href="../SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a></span><span class="tabEnd"> </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> |
| <tbody> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#columnQuery(java.lang.String)">columnQuery</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 values (as Object[]) and uses default routing</div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#columnQuery(java.lang.String,java.lang.Class...)">columnQuery</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 query that selects scalar values (as Object[]) and uses default routing</div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#columnQuery(java.lang.String,java.lang.String)">columnQuery</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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#columnQuery(java.lang.String,java.lang.String,java.lang.Class...)">columnQuery</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><?>... 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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#limit(int)">limit</a></span>​(int fetchLimit)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 class="rowColor"> |
| <td class="colFirst"><code><E> <a href="../SQLSelect.html" title="class in org.apache.cayenne.query">SQLSelect</a><E></code></td> |
| <th class="colSecond" scope="row"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#map(java.util.function.Function)">map</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/function/Function.html?is-external=true" title="class or interface in java.util.function" class="externalLink">Function</a><<a href="../SQLSelect.html" title="type parameter in SQLSelect">T</a>,​E> mapper)</code></th> |
| <td class="colLast"> |
| <div class="block">Map result of this query by processing with a given function.</div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#offset(int)">offset</a></span>​(int fetchOffset)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#pageSize(int)">pageSize</a></span>​(int pageSize)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#param(java.lang.String,java.lang.Object)">param</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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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"> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2 |
| Use <a href="../SQLSelect.html#param(java.lang.String,java.lang.Object)"><code>param(String, Object)</code></a></div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#queryTimeout(int)">queryTimeout</a></span>​(int queryTimeout)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets query timeout</div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2.</div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2.</div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2.</div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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><?>... types)</code></th> |
| <td class="colLast"> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2.</div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2.</div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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><?>... types)</code></th> |
| <td class="colLast"> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2.</div> |
| </div> |
| </td> |
| </tr> |
| <tr 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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 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"><span class="typeNameLabel">SQLSelect.</span><code><span class="memberNameLink"><a href="../SQLSelect.html#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> |
| </tbody> |
| </table> |
| </section> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| </main> |
| <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><a href="../SQLSelect.html" title="class in org.apache.cayenne.query">Class</a></li> |
| <li class="navBarCell1Rev">Use</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> |
| <a id="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| </nav> |
| <p class="legalCopy"><small>Copyright © 2001–2022 <a href="https://cayenne.apache.org/">Apache Cayenne</a>. All rights reserved.</small></p> |
| </footer> |
| </body> |
| </html> |
