src/main/site/static/docs/4.2/api/org/apache/cayenne/query/SQLTemplate.html - cayenne-website - Git at Google

 <!DOCTYPE HTML>
 <!-- NewPage -->
 <html lang="en">
 <head>
 <!-- Generated by javadoc (11.0.10) on Mon Dec 05 10:27:04 MSK 2022 -->
 <title>SQLTemplate (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="SQLTemplate (cayenne-doc: Cayenne Documentation 4.2.RC2 API)";
         }
     }
     catch(err) {
     }
 //-->
 var data = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"i7":10,"i8":10,"i9":10,"i10":10,"i11":10,"i12":10,"i13":10,"i14":10,"i15":10,"i16":10,"i17":10,"i18":10,"i19":10,"i20":10,"i21":10,"i22":10,"i23":10,"i24":10,"i25":10,"i26":10,"i27":10,"i28":10,"i29":10,"i30":10,"i31":10,"i32":10,"i33":10,"i34":10,"i35":10,"i36":10,"i37":10,"i38":10,"i39":10,"i40":10,"i41":10,"i42":10,"i43":10,"i44":10,"i45":10,"i46":10,"i47":10,"i48":10,"i49":10,"i50":10,"i51":10,"i52":10,"i53":10,"i54":10,"i55":10};
 var tabs = {65535:["t0","All 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 = 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 class="navBarCell1Rev">Class</li>
 <li><a href="class-use/SQLTemplate.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&nbsp;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:&nbsp;</li>
 <li>Nested&nbsp;|&nbsp;</li>
 <li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
 <li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.detail">Method</a></li>
 </ul>
 </div>
 <a id="skip.navbar.top">
 <!--   -->
 </a></div>
 <!-- ========= END OF TOP NAVBAR ========= -->
 </div>
 <div class="navPadding">&nbsp;</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>&nbsp;<a href="package-summary.html">org.apache.cayenne.query</a></div>
 <h2 title="Class SQLTemplate" class="title">Class SQLTemplate</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="CacheableQuery.html" title="class in org.apache.cayenne.query">org.apache.cayenne.query.CacheableQuery</a></li>
 <li>
 <ul class="inheritance">
 <li><a href="AbstractQuery.html" title="class in org.apache.cayenne.query">org.apache.cayenne.query.AbstractQuery</a></li>
 <li>
 <ul class="inheritance">
 <li>org.apache.cayenne.query.SQLTemplate</li>
 </ul>
 </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="ParameterizedQuery.html" title="interface in org.apache.cayenne.query">ParameterizedQuery</a></code>, <code><a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code></dd>
 </dl>
 <hr>
 <pre>public class <span class="typeNameLabel">SQLTemplate</span>
 extends <a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a>
 implements <a href="ParameterizedQuery.html" title="interface in org.apache.cayenne.query">ParameterizedQuery</a></pre>
 <div class="block">A query that executes unchanged (except for template preprocessing) "raw" SQL
  specified by the user. <h3>Template Script</h3>
  <p>
  SQLTemplate stores a dynamic template for the SQL query that supports
  parameters and customization using Velocity scripting language. The most
  straightforward use of scripting abilities is to build parameterized queries.
  For example:
  </p>

  <pre>
                   SELECT ID, NAME FROM SOME_TABLE WHERE NAME LIKE $a
  </pre>
  <p>
  <i>For advanced scripting options see "Scripting SQLTemplate" chapter in the
  User Guide. </i>
  </p>
  <h3>Per-Database Template Customization</h3>
  <p>
  SQLTemplate has a <a href="#getDefaultTemplate()"><code>default template script</code></a>, but
  also it allows to configure multiple templates and switch them dynamically.
  This way a single query can have multiple "dialects" specific to a given
  database.
  </p></div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.1</dd>
 <dt><span class="seeLabel">See Also:</span></dt>
 <dd><a href="../../../../serialized-form.html#org.apache.cayenne.query.SQLTemplate">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">&nbsp;</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>static <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="#COLUMN_NAME_CAPITALIZATION_PROPERTY">COLUMN_NAME_CAPITALIZATION_PROPERTY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <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="#columnNamesCapitalization">columnNamesCapitalization</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </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="#defaultTemplate">defaultTemplate</a></span></code></th>
 <td class="colLast">&nbsp;</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>&lt;<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>,&#8203;?&gt;[]</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#parameters">parameters</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <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>&lt;<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>&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#positionalParams">positionalParams</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>protected <a href="../map/SQLResult.html" title="class in org.apache.cayenne.map">SQLResult</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#result">result</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>protected boolean</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#returnGeneratedKeys">returnGeneratedKeys</a></span></code></th>
 <td class="colLast">&nbsp;</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>&lt;<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>,&#8203;<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>&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#templates">templates</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 </table>
 <ul class="blockList">
 <li class="blockList"><a id="fields.inherited.from.class.org.apache.cayenne.query.AbstractQuery">
 <!--   -->
 </a>
 <h3>Fields inherited from class&nbsp;org.apache.cayenne.query.<a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a></h3>
 <code><a href="AbstractQuery.html#root">root</a></code></li>
 </ul>
 <ul class="blockList">
 <li class="blockList"><a id="fields.inherited.from.class.org.apache.cayenne.query.CacheableQuery">
 <!--   -->
 </a>
 <h3>Fields inherited from class&nbsp;org.apache.cayenne.query.<a href="CacheableQuery.html" title="class in org.apache.cayenne.query">CacheableQuery</a></h3>
 <code><a href="CacheableQuery.html#logger">logger</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">&nbsp;</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()">SQLTemplate</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Creates an empty SQLTemplate.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.Class,java.lang.String)">SQLTemplate</a></span>&#8203;(<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>&lt;?&gt;&nbsp;rootClass,
            <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>&nbsp;defaultTemplate)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.String,boolean)">SQLTemplate</a></span>&#8203;(<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>&nbsp;defaultTemplate,
            boolean&nbsp;isFetchingDataRows)</code></th>
 <td class="colLast">
 <div class="block">Creates a SQLTemplate without an explicit root.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.String,java.lang.String)">SQLTemplate</a></span>&#8203;(<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>&nbsp;objEntityName,
            <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>&nbsp;defaultTemplate)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(org.apache.cayenne.map.DataMap,java.lang.String,boolean)">SQLTemplate</a></span>&#8203;(<a href="../map/DataMap.html" title="class in org.apache.cayenne.map">DataMap</a>&nbsp;rootMap,
            <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>&nbsp;defaultTemplate,
            boolean&nbsp;isFetchingDataRows)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(org.apache.cayenne.map.DbEntity,java.lang.String)">SQLTemplate</a></span>&#8203;(<a href="../map/DbEntity.html" title="class in org.apache.cayenne.map">DbEntity</a>&nbsp;rootEntity,
            <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>&nbsp;defaultTemplate)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(org.apache.cayenne.map.ObjEntity,java.lang.String)">SQLTemplate</a></span>&#8203;(<a href="../map/ObjEntity.html" title="class in org.apache.cayenne.map">ObjEntity</a>&nbsp;rootEntity,
            <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>&nbsp;defaultTemplate)</code></th>
 <td class="colLast">&nbsp;</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">&nbsp;</span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
 <tr>
 <th class="colFirst" scope="col">Modifier and Type</th>
 <th class="colSecond" scope="col">Method</th>
 <th class="colLast" scope="col">Description</th>
 </tr>
 <tr id="i0" class="altColor">
 <td class="colFirst"><code><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="#addPrefetch(java.lang.String)">addPrefetch</a></span>&#8203;(<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>&nbsp;prefetchPath)</code></th>
 <td class="colLast">
 <div class="block">Adds a prefetch.</div>
 </td>
 </tr>
 <tr id="i1" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#addPrefetch(org.apache.cayenne.query.PrefetchTreeNode)">addPrefetch</a></span>&#8203;(<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a>&nbsp;prefetchElement)</code></th>
 <td class="colLast">
 <div class="block">Adds a prefetch with specified relationship path to the query.</div>
 </td>
 </tr>
 <tr id="i2" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#addPrefetches(java.util.Collection)">addPrefetches</a></span>&#8203;(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a>&lt;<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>&gt;&nbsp;prefetches)</code></th>
 <td class="colLast">
 <div class="block">Adds all prefetches from a provided collection.</div>
 </td>
 </tr>
 <tr id="i3" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#clearPrefetches()">clearPrefetches</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Clears all prefetches.</div>
 </td>
 </tr>
 <tr id="i4" class="altColor">
 <td class="colFirst"><code><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="#createQuery(java.util.Map)">createQuery</a></span>&#8203;(<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>&lt;<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>,&#8203;?&gt;&nbsp;parameters)</code></th>
 <td class="colLast">
 <div class="block">Creates and returns a new SQLTemplate built using this query as a
  prototype and substituting template parameters with the values from the
  map.</div>
 </td>
 </tr>
 <tr id="i5" class="rowColor">
 <td class="colFirst"><code><a href="SQLAction.html" title="interface in org.apache.cayenne.query">SQLAction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a></span>&#8203;(<a href="SQLActionVisitor.html" title="interface in org.apache.cayenne.query">SQLActionVisitor</a>&nbsp;visitor)</code></th>
 <td class="colLast">
 <div class="block">Calls <em>sqlAction(this)</em> on the visitor.</div>
 </td>
 </tr>
 <tr id="i6" class="altColor">
 <td class="colFirst"><code>protected org.apache.cayenne.query.BaseQueryMetadata</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getBaseMetaData()">getBaseMetaData</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i7" 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="#getColumnNamesCapitalization()">getColumnNamesCapitalization</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="i8" class="altColor">
 <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="#getCustomTemplate(java.lang.String)">getCustomTemplate</a></span>&#8203;(<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>&nbsp;key)</code></th>
 <td class="colLast">
 <div class="block">Returns template for key, or null if there is no template configured for
  this key.</div>
 </td>
 </tr>
 <tr id="i9" 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="#getDataNodeName()">getDataNodeName</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns a name of the DataNode to use with this SQLTemplate.</div>
 </td>
 </tr>
 <tr id="i10" class="altColor">
 <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="#getDefaultTemplate()">getDefaultTemplate</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns default SQL template for this query.</div>
 </td>
 </tr>
 <tr id="i11" class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getFetchLimit()">getFetchLimit</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i12" class="altColor">
 <td class="colFirst"><code>int</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getFetchOffset()">getFetchOffset</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i13" class="rowColor">
 <td class="colFirst"><code><a href="QueryMetadata.html" title="interface in org.apache.cayenne.query">QueryMetadata</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a></span>&#8203;(<a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a>&nbsp;resolver)</code></th>
 <td class="colLast">
 <div class="block">Returns default select parameters.</div>
 </td>
 </tr>
 <tr id="i14" 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">&nbsp;</td>
 </tr>
 <tr id="i15" 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>&lt;<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>,&#8203;?&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getParameters()">getParameters</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Utility method to get the first set of parameters, since most queries
  will only have one.</div>
 </td>
 </tr>
 <tr id="i16" class="altColor">
 <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>&lt;<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>,&#8203;?&gt;</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 map of named parameters that will be bound to SQL.</div>
 </td>
 </tr>
 <tr id="i17" class="rowColor">
 <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a>&lt;<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>&gt;</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 list of positional parameters that will be bound to SQL.</div>
 </td>
 </tr>
 <tr id="i18" class="altColor">
 <td class="colFirst"><code><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="#getPrefetchTree()">getPrefetchTree</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i19" class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getQueryTimeout()">getQueryTimeout</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i20" class="altColor">
 <td class="colFirst"><code><a href="../map/SQLResult.html" title="class in org.apache.cayenne.map">SQLResult</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getResult()">getResult</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i21" 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>&lt;<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>&lt;?&gt;&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getResultColumnsTypes()">getResultColumnsTypes</a></span>()</code></th>
 <td class="colLast">&nbsp;</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">&nbsp;</td>
 </tr>
 <tr id="i23" 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="#getTemplate(java.lang.String)">getTemplate</a></span>&#8203;(<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>&nbsp;key)</code></th>
 <td class="colLast">
 <div class="block">Returns a template for key, or a default template if a template for key
  is not found.</div>
 </td>
 </tr>
 <tr id="i24" class="altColor">
 <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a>&lt;<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>&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getTemplateKeys()">getTemplateKeys</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns a collection of configured template keys.</div>
 </td>
 </tr>
 <tr id="i25" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#initWithProperties(java.util.Map)">initWithProperties</a></span>&#8203;(<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>&lt;<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>,&#8203;?&gt;&nbsp;properties)</code></th>
 <td class="colLast">
 <div class="block">Initializes query parameters using a set of properties.</div>
 </td>
 </tr>
 <tr id="i26" class="altColor">
 <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">&nbsp;</td>
 </tr>
 <tr id="i27" class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isReturnGeneratedKeys()">isReturnGeneratedKeys</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i28" class="altColor">
 <td class="colFirst"><code>boolean</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isUseScalar()">isUseScalar</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i29" class="rowColor">
 <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/Iterator.html?is-external=true" title="class or interface in java.util" class="externalLink">Iterator</a>&lt;<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>&lt;<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>,&#8203;?&gt;&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#parametersIterator()">parametersIterator</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns an iterator over parameter sets.</div>
 </td>
 </tr>
 <tr id="i30" class="altColor">
 <td class="colFirst"><code>int</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#parametersSize()">parametersSize</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns the number of parameter sets.</div>
 </td>
 </tr>
 <tr id="i31" class="rowColor">
 <td class="colFirst"><code><a href="SQLTemplate.html" title="class in org.apache.cayenne.query">SQLTemplate</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#queryWithParameters(java.util.Map...)">queryWithParameters</a></span>&#8203;(<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>&lt;<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>,&#8203;?&gt;...&nbsp;parameters)</code></th>
 <td class="colLast">
 <div class="block">Returns a new query built using this query as a prototype and a new set
  of parameters.</div>
 </td>
 </tr>
 <tr id="i32" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#removePrefetch(java.lang.String)">removePrefetch</a></span>&#8203;(<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>&nbsp;prefetch)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i33" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#removeTemplate(java.lang.String)">removeTemplate</a></span>&#8203;(<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>&nbsp;key)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i34" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">route</a></span>&#8203;(<a href="QueryRouter.html" title="interface in org.apache.cayenne.query">QueryRouter</a>&nbsp;router,
      <a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a>&nbsp;resolver,
      <a href="Query.html" title="interface in org.apache.cayenne.query">Query</a>&nbsp;substitutedQuery)</code></th>
 <td class="colLast">
 <div class="block">Implements default routing mechanism relying on the EntityResolver to find DataMap
  based on the query root.</div>
 </td>
 </tr>
 <tr id="i35" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setColumnNamesCapitalization(org.apache.cayenne.query.CapsStrategy)">setColumnNamesCapitalization</a></span>&#8203;(<a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a>&nbsp;columnNameCapitalization)</code></th>
 <td class="colLast">
 <div class="block">Sets a column name capitalization policy applied to selecting queries.</div>
 </td>
 </tr>
 <tr id="i36" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setDataNodeName(java.lang.String)">setDataNodeName</a></span>&#8203;(<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>&nbsp;dataNodeName)</code></th>
 <td class="colLast">
 <div class="block">Sets a name of the DataNode to use with this SQLTemplate.</div>
 </td>
 </tr>
 <tr id="i37" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setDefaultTemplate(java.lang.String)">setDefaultTemplate</a></span>&#8203;(<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>&nbsp;string)</code></th>
 <td class="colLast">
 <div class="block">Sets default SQL template for this query.</div>
 </td>
 </tr>
 <tr id="i38" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setFetchingDataRows(boolean)">setFetchingDataRows</a></span>&#8203;(boolean&nbsp;flag)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i39" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setFetchLimit(int)">setFetchLimit</a></span>&#8203;(int&nbsp;fetchLimit)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i40" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setFetchOffset(int)">setFetchOffset</a></span>&#8203;(int&nbsp;fetchOffset)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i41" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setPageSize(int)">setPageSize</a></span>&#8203;(int&nbsp;pageSize)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i42" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setParameters(java.util.Map...)">setParameters</a></span>&#8203;(<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>&lt;<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>,&#8203;?&gt;...&nbsp;parameters)</code></th>
 <td class="colLast">
 <div class="block">Utility method to initialize query with one or more sets of parameters.</div>
 </td>
 </tr>
 <tr id="i43" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setParams(java.util.Map)">setParams</a></span>&#8203;(<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>&lt;<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>,&#8203;?&gt;&nbsp;params)</code></th>
 <td class="colLast">
 <div class="block">Initializes named parameter of this query.</div>
 </td>
 </tr>
 <tr id="i44" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setParamsArray(java.lang.Object...)">setParamsArray</a></span>&#8203;(<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>...&nbsp;params)</code></th>
 <td class="colLast">
 <div class="block">Initializes positional parameters of the query.</div>
 </td>
 </tr>
 <tr id="i45" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setParamsList(java.util.List)">setParamsList</a></span>&#8203;(<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>&lt;<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>&gt;&nbsp;params)</code></th>
 <td class="colLast">
 <div class="block">Initializes positional parameters of the query.</div>
 </td>
 </tr>
 <tr id="i46" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setQueryTimeout(int)">setQueryTimeout</a></span>&#8203;(int&nbsp;queryTimeout)</code></th>
 <td class="colLast">
 <div class="block">Sets query timeout.</div>
 </td>
 </tr>
 <tr id="i47" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setResult(org.apache.cayenne.map.SQLResult)">setResult</a></span>&#8203;(<a href="../map/SQLResult.html" title="class in org.apache.cayenne.map">SQLResult</a>&nbsp;resultSet)</code></th>
 <td class="colLast">
 <div class="block">Sets an optional explicit mapping of the result set.</div>
 </td>
 </tr>
 <tr id="i48" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setResultColumnsTypes(java.lang.Class...)">setResultColumnsTypes</a></span>&#8203;(<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>&lt;?&gt;...&nbsp;types)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i49" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setResultColumnsTypes(java.util.List)">setResultColumnsTypes</a></span>&#8203;(<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>&lt;<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>&lt;?&gt;&gt;&nbsp;resultColumnsTypes)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i50" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setResultMapper(java.util.function.Function)">setResultMapper</a></span>&#8203;(<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>&lt;?,&#8203;?&gt;&nbsp;resultMapper)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i51" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setReturnGeneratedKeys(boolean)">setReturnGeneratedKeys</a></span>&#8203;(boolean&nbsp;returnGeneratedKeys)</code></th>
 <td class="colLast">
 <div class="block">Sets flag to return generated keys.</div>
 </td>
 </tr>
 <tr id="i52" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setRoot(java.lang.Object)">setRoot</a></span>&#8203;(<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>&nbsp;value)</code></th>
 <td class="colLast">
 <div class="block">Sets the root of the query</div>
 </td>
 </tr>
 <tr id="i53" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setStatementFetchSize(int)">setStatementFetchSize</a></span>&#8203;(int&nbsp;size)</code></th>
 <td class="colLast">
 <div class="block">Sets statement's fetch size (0 for no default size)</div>
 </td>
 </tr>
 <tr id="i54" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setTemplate(java.lang.String,java.lang.String)">setTemplate</a></span>&#8203;(<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>&nbsp;key,
            <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>&nbsp;template)</code></th>
 <td class="colLast">
 <div class="block">Adds a SQL template string for a given key.</div>
 </td>
 </tr>
 <tr id="i55" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setUseScalar(boolean)">setUseScalar</a></span>&#8203;(boolean&nbsp;useScalar)</code></th>
 <td class="colLast">
 <div class="block">Sets flag to use scalars.</div>
 </td>
 </tr>
 </table>
 <ul class="blockList">
 <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.AbstractQuery">
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;org.apache.cayenne.query.<a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a></h3>
 <code><a href="AbstractQuery.html#getRoot()">getRoot</a>, <a href="AbstractQuery.html#toString()">toString</a></code></li>
 </ul>
 <ul class="blockList">
 <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.CacheableQuery">
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;org.apache.cayenne.query.<a href="CacheableQuery.html" title="class in org.apache.cayenne.query">CacheableQuery</a></h3>
 <code><a href="CacheableQuery.html#getCacheGroup()">getCacheGroup</a>, <a href="CacheableQuery.html#getCacheStrategy()">getCacheStrategy</a>, <a href="CacheableQuery.html#setCacheGroup(java.lang.String)">setCacheGroup</a>, <a href="CacheableQuery.html#setCacheStrategy(org.apache.cayenne.query.QueryCacheStrategy)">setCacheStrategy</a>, <a href="CacheableQuery.html#useLocalCache()">useLocalCache</a>, <a href="CacheableQuery.html#useLocalCache(java.lang.String)">useLocalCache</a>, <a href="CacheableQuery.html#useSharedCache()">useSharedCache</a>, <a href="CacheableQuery.html#useSharedCache(java.lang.String)">useSharedCache</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&nbsp;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#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>
 </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="COLUMN_NAME_CAPITALIZATION_PROPERTY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COLUMN_NAME_CAPITALIZATION_PROPERTY</h4>
 <pre>public static final&nbsp;<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> COLUMN_NAME_CAPITALIZATION_PROPERTY</pre>
 <dl>
 <dt><span class="seeLabel">See Also:</span></dt>
 <dd><a href="../../../../constant-values.html#org.apache.cayenne.query.SQLTemplate.COLUMN_NAME_CAPITALIZATION_PROPERTY">Constant Field Values</a></dd>
 </dl>
 </li>
 </ul>
 <a id="defaultTemplate">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>defaultTemplate</h4>
 <pre>protected&nbsp;<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> defaultTemplate</pre>
 </li>
 </ul>
 <a id="templates">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>templates</h4>
 <pre>protected&nbsp;<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>&lt;<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>,&#8203;<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>&gt; templates</pre>
 </li>
 </ul>
 <a id="parameters">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>parameters</h4>
 <pre>protected&nbsp;<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>&lt;<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>,&#8203;?&gt;[] parameters</pre>
 </li>
 </ul>
 <a id="positionalParams">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>positionalParams</h4>
 <pre>protected&nbsp;<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>&lt;<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>&gt; positionalParams</pre>
 </li>
 </ul>
 <a id="columnNamesCapitalization">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>columnNamesCapitalization</h4>
 <pre>protected&nbsp;<a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a> columnNamesCapitalization</pre>
 </li>
 </ul>
 <a id="result">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>result</h4>
 <pre>protected&nbsp;<a href="../map/SQLResult.html" title="class in org.apache.cayenne.map">SQLResult</a> result</pre>
 </li>
 </ul>
 <a id="returnGeneratedKeys">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>returnGeneratedKeys</h4>
 <pre>protected&nbsp;boolean returnGeneratedKeys</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="&lt;init&gt;()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate()</pre>
 <div class="block">Creates an empty SQLTemplate. Note this constructor does not specify the
  "root" of the query, so a user must call "setRoot" later to make sure
  SQLTemplate can be executed.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="&lt;init&gt;(java.lang.String,boolean)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate&#8203;(<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>&nbsp;defaultTemplate,
                    boolean&nbsp;isFetchingDataRows)</pre>
 <div class="block">Creates a SQLTemplate without an explicit root.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="&lt;init&gt;(org.apache.cayenne.map.DataMap,java.lang.String,boolean)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate&#8203;(<a href="../map/DataMap.html" title="class in org.apache.cayenne.map">DataMap</a>&nbsp;rootMap,
                    <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>&nbsp;defaultTemplate,
                    boolean&nbsp;isFetchingDataRows)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.1</dd>
 </dl>
 </li>
 </ul>
 <a id="&lt;init&gt;(org.apache.cayenne.map.ObjEntity,java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate&#8203;(<a href="../map/ObjEntity.html" title="class in org.apache.cayenne.map">ObjEntity</a>&nbsp;rootEntity,
                    <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>&nbsp;defaultTemplate)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="&lt;init&gt;(java.lang.Class,java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate&#8203;(<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>&lt;?&gt;&nbsp;rootClass,
                    <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>&nbsp;defaultTemplate)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="&lt;init&gt;(org.apache.cayenne.map.DbEntity,java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate&#8203;(<a href="../map/DbEntity.html" title="class in org.apache.cayenne.map">DbEntity</a>&nbsp;rootEntity,
                    <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>&nbsp;defaultTemplate)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="&lt;init&gt;(java.lang.String,java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>SQLTemplate</h4>
 <pre>public&nbsp;SQLTemplate&#8203;(<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>&nbsp;objEntityName,
                    <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>&nbsp;defaultTemplate)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </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="setResultColumnsTypes(java.lang.Class...)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setResultColumnsTypes</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setResultColumnsTypes&#8203;(<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>&lt;?&gt;...&nbsp;types)</pre>
 </li>
 </ul>
 <a id="setRoot(java.lang.Object)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setRoot</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setRoot&#8203;(<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>&nbsp;value)</pre>
 <div class="block"><span class="descfrmTypeLabel">Description copied from class:&nbsp;<code><a href="AbstractQuery.html#setRoot(java.lang.Object)">AbstractQuery</a></code></span></div>
 <div class="block">Sets the root of the query</div>
 <dl>
 <dt><span class="overrideSpecifyLabel">Overrides:</span></dt>
 <dd><code><a href="AbstractQuery.html#setRoot(java.lang.Object)">setRoot</a></code>&nbsp;in class&nbsp;<code><a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a></code></dd>
 <dt><span class="paramLabel">Parameters:</span></dt>
 <dd><code>value</code> - The new root</dd>
 </dl>
 </li>
 </ul>
 <a id="route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>route</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;route&#8203;(<a href="QueryRouter.html" title="interface in org.apache.cayenne.query">QueryRouter</a>&nbsp;router,
                   <a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a>&nbsp;resolver,
                   <a href="Query.html" title="interface in org.apache.cayenne.query">Query</a>&nbsp;substitutedQuery)</pre>
 <div class="block"><span class="descfrmTypeLabel">Description copied from class:&nbsp;<code><a href="AbstractQuery.html#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">AbstractQuery</a></code></span></div>
 <div class="block">Implements default routing mechanism relying on the EntityResolver to find DataMap
  based on the query root. This mechanism should be sufficient for most queries that
  "know" their root.</div>
 <dl>
 <dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
 <dd><code><a href="Query.html#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">route</a></code>&nbsp;in interface&nbsp;<code><a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code></dd>
 <dt><span class="overrideSpecifyLabel">Overrides:</span></dt>
 <dd><code><a href="AbstractQuery.html#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">route</a></code>&nbsp;in class&nbsp;<code><a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a></code></dd>
 </dl>
 </li>
 </ul>
 <a id="getMetaData(org.apache.cayenne.map.EntityResolver)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getMetaData</h4>
 <pre class="methodSignature">public&nbsp;<a href="QueryMetadata.html" title="interface in org.apache.cayenne.query">QueryMetadata</a>&nbsp;getMetaData&#8203;(<a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a>&nbsp;resolver)</pre>
 <div class="block"><span class="descfrmTypeLabel">Description copied from class:&nbsp;<code><a href="AbstractQuery.html#getMetaData(org.apache.cayenne.map.EntityResolver)">AbstractQuery</a></code></span></div>
 <div class="block">Returns default select parameters.</div>
 <dl>
 <dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
 <dd><code><a href="Query.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a></code>&nbsp;in interface&nbsp;<code><a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code></dd>
 <dt><span class="overrideSpecifyLabel">Overrides:</span></dt>
 <dd><code><a href="AbstractQuery.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a></code>&nbsp;in class&nbsp;<code><a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a></code></dd>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>createSQLAction</h4>
 <pre class="methodSignature">public&nbsp;<a href="SQLAction.html" title="interface in org.apache.cayenne.query">SQLAction</a>&nbsp;createSQLAction&#8203;(<a href="SQLActionVisitor.html" title="interface in org.apache.cayenne.query">SQLActionVisitor</a>&nbsp;visitor)</pre>
 <div class="block">Calls <em>sqlAction(this)</em> on the visitor.</div>
 <dl>
 <dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
 <dd><code><a href="Query.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a></code>&nbsp;in interface&nbsp;<code><a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code></dd>
 <dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
 <dd><code><a href="AbstractQuery.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a></code>&nbsp;in class&nbsp;<code><a href="AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</a></code></dd>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="initWithProperties(java.util.Map)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>initWithProperties</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;initWithProperties&#8203;(<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>&lt;<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>,&#8203;?&gt;&nbsp;properties)</pre>
 <div class="block">Initializes query parameters using a set of properties.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.1</dd>
 </dl>
 </li>
 </ul>
 <a id="parametersIterator()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>parametersIterator</h4>
 <pre class="methodSignature">public&nbsp;<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Iterator.html?is-external=true" title="class or interface in java.util" class="externalLink">Iterator</a>&lt;<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>&lt;<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>,&#8203;?&gt;&gt;&nbsp;parametersIterator()</pre>
 <div class="block">Returns an iterator over parameter sets. Each element returned from the
  iterator is a java.util.Map.</div>
 </li>
 </ul>
 <a id="parametersSize()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>parametersSize</h4>
 <pre class="methodSignature">public&nbsp;int&nbsp;parametersSize()</pre>
 <div class="block">Returns the number of parameter sets.</div>
 </li>
 </ul>
 <a id="setParams(java.util.Map)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setParams</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setParams&#8203;(<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>&lt;<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>,&#8203;?&gt;&nbsp;params)</pre>
 <div class="block">Initializes named parameter of this query. Note that calling this method
  will reset any positional parameters.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setParamsArray(java.lang.Object...)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setParamsArray</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setParamsArray&#8203;(<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>...&nbsp;params)</pre>
 <div class="block">Initializes positional parameters of the query. Parameters are bound in
  the order they are found in the SQL template. If a given parameter name
  is used more than once, only the first occurrence is treated as
  "position", subsequent occurrences are bound with the same value as the
  first one. If template parameters count is different from the array
  parameter count, an exception will be thrown.
  <p>
  Note that calling this method will reset any previously set *named*
  parameters.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setParamsList(java.util.List)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setParamsList</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setParamsList&#8203;(<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>&lt;<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>&gt;&nbsp;params)</pre>
 <div class="block">Initializes positional parameters of the query. Parameters are bound in
  the order they are found in the SQL template. If a given parameter name
  is used more than once, only the first occurrence is treated as
  "position", subsequent occurrences are bound with the same value as the
  first one. If template parameters count is different from the list
  parameter count, an exception will be thrown.
  <p>
  Note that calling this method will reset any previously set *named*
  parameters.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="queryWithParameters(java.util.Map...)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>queryWithParameters</h4>
 <pre class="methodSignature">public&nbsp;<a href="SQLTemplate.html" title="class in org.apache.cayenne.query">SQLTemplate</a>&nbsp;queryWithParameters&#8203;(<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>&lt;<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>,&#8203;?&gt;...&nbsp;parameters)</pre>
 <div class="block">Returns a new query built using this query as a prototype and a new set
  of parameters.</div>
 </li>
 </ul>
 <a id="createQuery(java.util.Map)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>createQuery</h4>
 <pre class="methodSignature">public&nbsp;<a href="Query.html" title="interface in org.apache.cayenne.query">Query</a>&nbsp;createQuery&#8203;(<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>&lt;<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>,&#8203;?&gt;&nbsp;parameters)</pre>
 <div class="block">Creates and returns a new SQLTemplate built using this query as a
  prototype and substituting template parameters with the values from the
  map.</div>
 <dl>
 <dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
 <dd><code><a href="ParameterizedQuery.html#createQuery(java.util.Map)">createQuery</a></code>&nbsp;in interface&nbsp;<code><a href="ParameterizedQuery.html" title="interface in org.apache.cayenne.query">ParameterizedQuery</a></code></dd>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.1</dd>
 </dl>
 </li>
 </ul>
 <a id="getBaseMetaData()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getBaseMetaData</h4>
 <pre class="methodSignature">protected&nbsp;org.apache.cayenne.query.BaseQueryMetadata&nbsp;getBaseMetaData()</pre>
 <dl>
 <dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
 <dd><code><a href="CacheableQuery.html#getBaseMetaData()">getBaseMetaData</a></code>&nbsp;in class&nbsp;<code><a href="CacheableQuery.html" title="class in org.apache.cayenne.query">CacheableQuery</a></code></dd>
 </dl>
 </li>
 </ul>
 <a id="getFetchLimit()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getFetchLimit</h4>
 <pre class="methodSignature">public&nbsp;int&nbsp;getFetchLimit()</pre>
 </li>
 </ul>
 <a id="setFetchLimit(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setFetchLimit</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setFetchLimit&#8203;(int&nbsp;fetchLimit)</pre>
 </li>
 </ul>
 <a id="getFetchOffset()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getFetchOffset</h4>
 <pre class="methodSignature">public&nbsp;int&nbsp;getFetchOffset()</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setFetchOffset(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setFetchOffset</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setFetchOffset&#8203;(int&nbsp;fetchOffset)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="getPageSize()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getPageSize</h4>
 <pre class="methodSignature">public&nbsp;int&nbsp;getPageSize()</pre>
 </li>
 </ul>
 <a id="setPageSize(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setPageSize</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setPageSize&#8203;(int&nbsp;pageSize)</pre>
 </li>
 </ul>
 <a id="setFetchingDataRows(boolean)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setFetchingDataRows</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setFetchingDataRows&#8203;(boolean&nbsp;flag)</pre>
 </li>
 </ul>
 <a id="isFetchingDataRows()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>isFetchingDataRows</h4>
 <pre class="methodSignature">public&nbsp;boolean&nbsp;isFetchingDataRows()</pre>
 </li>
 </ul>
 <a id="getDefaultTemplate()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getDefaultTemplate</h4>
 <pre class="methodSignature">public&nbsp;<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>&nbsp;getDefaultTemplate()</pre>
 <div class="block">Returns default SQL template for this query.</div>
 </li>
 </ul>
 <a id="setDefaultTemplate(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setDefaultTemplate</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setDefaultTemplate&#8203;(<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>&nbsp;string)</pre>
 <div class="block">Sets default SQL template for this query.</div>
 </li>
 </ul>
 <a id="getTemplate(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getTemplate</h4>
 <pre class="methodSignature">public&nbsp;<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>&nbsp;getTemplate&#8203;(<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>&nbsp;key)</pre>
 <div class="block">Returns a template for key, or a default template if a template for key
  is not found.</div>
 </li>
 </ul>
 <a id="getCustomTemplate(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getCustomTemplate</h4>
 <pre class="methodSignature">public&nbsp;<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>&nbsp;getCustomTemplate&#8203;(<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>&nbsp;key)</pre>
 <div class="block">Returns template for key, or null if there is no template configured for
  this key. Unlike <a href="#getTemplate(java.lang.String)"><code>getTemplate(String)</code></a>this method does not return
  a default template as a failover strategy, rather it returns null.</div>
 </li>
 </ul>
 <a id="setTemplate(java.lang.String,java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setTemplate</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setTemplate&#8203;(<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>&nbsp;key,
                         <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>&nbsp;template)</pre>
 <div class="block">Adds a SQL template string for a given key. Note the the keys understood
  by Cayenne must be fully qualified adapter class names. This way the
  framework can related current DataNode to the right template. E.g.
  "org.apache.cayenne.dba.oracle.OracleAdapter" is a key that should be
  used to setup an Oracle-specific template.</div>
 <dl>
 <dt><span class="seeLabel">See Also:</span></dt>
 <dd><a href="#setDefaultTemplate(java.lang.String)"><code>setDefaultTemplate(String)</code></a></dd>
 </dl>
 </li>
 </ul>
 <a id="removeTemplate(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>removeTemplate</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;removeTemplate&#8203;(<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>&nbsp;key)</pre>
 </li>
 </ul>
 <a id="getTemplateKeys()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getTemplateKeys</h4>
 <pre class="methodSignature">public&nbsp;<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a>&lt;<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>&gt;&nbsp;getTemplateKeys()</pre>
 <div class="block">Returns a collection of configured template keys.</div>
 </li>
 </ul>
 <a id="getParams()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getParams</h4>
 <pre class="methodSignature">public&nbsp;<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>&lt;<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>,&#8203;?&gt;&nbsp;getParams()</pre>
 <div class="block">Returns a map of named parameters that will be bound to SQL.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="getPositionalParams()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getPositionalParams</h4>
 <pre class="methodSignature">public&nbsp;<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>&lt;<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>&gt;&nbsp;getPositionalParams()</pre>
 <div class="block">Returns a list of positional parameters that will be bound to SQL.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="getParameters()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getParameters</h4>
 <pre class="methodSignature">public&nbsp;<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>&lt;<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>,&#8203;?&gt;&nbsp;getParameters()</pre>
 <div class="block">Utility method to get the first set of parameters, since most queries
  will only have one.</div>
 </li>
 </ul>
 <a id="setParameters(java.util.Map...)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setParameters</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setParameters&#8203;(<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>&lt;<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>,&#8203;?&gt;...&nbsp;parameters)</pre>
 <div class="block">Utility method to initialize query with one or more sets of parameters.</div>
 </li>
 </ul>
 <a id="getPrefetchTree()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getPrefetchTree</h4>
 <pre class="methodSignature">public&nbsp;<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a>&nbsp;getPrefetchTree()</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="addPrefetch(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>addPrefetch</h4>
 <pre class="methodSignature">public&nbsp;<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a>&nbsp;addPrefetch&#8203;(<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>&nbsp;prefetchPath)</pre>
 <div class="block">Adds a prefetch.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="addPrefetch(org.apache.cayenne.query.PrefetchTreeNode)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>addPrefetch</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;addPrefetch&#8203;(<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a>&nbsp;prefetchElement)</pre>
 <div class="block">Adds a prefetch with specified relationship path to the query.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="removePrefetch(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>removePrefetch</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;removePrefetch&#8203;(<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>&nbsp;prefetch)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="addPrefetches(java.util.Collection)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>addPrefetches</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;addPrefetches&#8203;(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a>&lt;<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>&gt;&nbsp;prefetches)</pre>
 <div class="block">Adds all prefetches from a provided collection.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="clearPrefetches()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>clearPrefetches</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;clearPrefetches()</pre>
 <div class="block">Clears all prefetches.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>1.2</dd>
 </dl>
 </li>
 </ul>
 <a id="getColumnNamesCapitalization()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getColumnNamesCapitalization</h4>
 <pre class="methodSignature">public&nbsp;<a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a>&nbsp;getColumnNamesCapitalization()</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>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setColumnNamesCapitalization(org.apache.cayenne.query.CapsStrategy)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setColumnNamesCapitalization</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setColumnNamesCapitalization&#8203;(<a href="CapsStrategy.html" title="enum in org.apache.cayenne.query">CapsStrategy</a>&nbsp;columnNameCapitalization)</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>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setResult(org.apache.cayenne.map.SQLResult)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setResult</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setResult&#8203;(<a href="../map/SQLResult.html" title="class in org.apache.cayenne.map">SQLResult</a>&nbsp;resultSet)</pre>
 <div class="block">Sets an optional explicit mapping of the result set. If result set
  mapping is specified, the result of SQLTemplate may not be a normal list
  of Persistent objects or DataRows, instead it will follow the
  <a href="../map/SQLResult.html" title="class in org.apache.cayenne.map"><code>SQLResult</code></a> rules.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="getResult()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getResult</h4>
 <pre class="methodSignature">public&nbsp;<a href="../map/SQLResult.html" title="class in org.apache.cayenne.map">SQLResult</a>&nbsp;getResult()</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setStatementFetchSize(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setStatementFetchSize</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setStatementFetchSize&#8203;(int&nbsp;size)</pre>
 <div class="block">Sets statement's fetch size (0 for no default size)</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="getStatementFetchSize()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getStatementFetchSize</h4>
 <pre class="methodSignature">public&nbsp;int&nbsp;getStatementFetchSize()</pre>
 <dl>
 <dt><span class="returnLabel">Returns:</span></dt>
 <dd>statement's fetch size</dd>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>3.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setQueryTimeout(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setQueryTimeout</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setQueryTimeout&#8203;(int&nbsp;queryTimeout)</pre>
 <div class="block">Sets query timeout.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.2</dd>
 </dl>
 </li>
 </ul>
 <a id="getQueryTimeout()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getQueryTimeout</h4>
 <pre class="methodSignature">public&nbsp;int&nbsp;getQueryTimeout()</pre>
 <dl>
 <dt><span class="returnLabel">Returns:</span></dt>
 <dd>query timeout</dd>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.2</dd>
 </dl>
 </li>
 </ul>
 <a id="getDataNodeName()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getDataNodeName</h4>
 <pre class="methodSignature">public&nbsp;<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>&nbsp;getDataNodeName()</pre>
 <div class="block">Returns a name of the DataNode to use with this SQLTemplate. This
  information will be used during query execution if no other routing
  information is provided such as entity name or class, etc.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="setDataNodeName(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setDataNodeName</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setDataNodeName&#8203;(<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>&nbsp;dataNodeName)</pre>
 <div class="block">Sets a name of the DataNode to use with this SQLTemplate. This
  information will be used during query execution if no other routing
  information is provided such as entity name or class, etc.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.0</dd>
 </dl>
 </li>
 </ul>
 <a id="isReturnGeneratedKeys()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>isReturnGeneratedKeys</h4>
 <pre class="methodSignature">public&nbsp;boolean&nbsp;isReturnGeneratedKeys()</pre>
 <dl>
 <dt><span class="returnLabel">Returns:</span></dt>
 <dd>returnGeneratedKeys flag</dd>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.1</dd>
 </dl>
 </li>
 </ul>
 <a id="setReturnGeneratedKeys(boolean)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setReturnGeneratedKeys</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setReturnGeneratedKeys&#8203;(boolean&nbsp;returnGeneratedKeys)</pre>
 <div class="block">Sets flag to return generated keys.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.1</dd>
 </dl>
 </li>
 </ul>
 <a id="getResultColumnsTypes()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getResultColumnsTypes</h4>
 <pre class="methodSignature">public&nbsp;<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>&lt;<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>&lt;?&gt;&gt;&nbsp;getResultColumnsTypes()</pre>
 </li>
 </ul>
 <a id="setResultColumnsTypes(java.util.List)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setResultColumnsTypes</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setResultColumnsTypes&#8203;(<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>&lt;<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>&lt;?&gt;&gt;&nbsp;resultColumnsTypes)</pre>
 </li>
 </ul>
 <a id="setUseScalar(boolean)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>setUseScalar</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setUseScalar&#8203;(boolean&nbsp;useScalar)</pre>
 <div class="block">Sets flag to use scalars.</div>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.1</dd>
 </dl>
 </li>
 </ul>
 <a id="isUseScalar()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>isUseScalar</h4>
 <pre class="methodSignature">public&nbsp;boolean&nbsp;isUseScalar()</pre>
 </li>
 </ul>
 <a id="setResultMapper(java.util.function.Function)">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>setResultMapper</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;setResultMapper&#8203;(<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>&lt;?,&#8203;?&gt;&nbsp;resultMapper)</pre>
 <dl>
 <dt><span class="simpleTagLabel">Since:</span></dt>
 <dd>4.2</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/SQLTemplate.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&nbsp;Classes</a></li>
 </ul>
 <div>
 <script type="text/javascript"><!--
   allClassesLink = document.getElementById("allclasses_navbar_bottom");
   if(window==top) {
     allClassesLink.style.display = "block";
   }
   else {
     allClassesLink.style.display = "none";
   }
   //-->
 </script>
 <noscript>
 <div>JavaScript is disabled on your browser.</div>
 </noscript>
 </div>
 <div>
 <ul class="subNavList">
 <li>Summary:&nbsp;</li>
 <li>Nested&nbsp;|&nbsp;</li>
 <li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
 <li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.detail">Method</a></li>
 </ul>
 </div>
 <a id="skip.navbar.bottom">
 <!--   -->
 </a></div>
 <!-- ======== END OF BOTTOM NAVBAR ======= -->
 </nav>
 <p class="legalCopy"><small>Copyright &#169; 2001&#x2013;2022 <a href="https://cayenne.apache.org/">Apache Cayenne</a>. All rights reserved.</small></p>
 </footer>
 </body>
 </html>