blob: 86611429d35fa7166fb7ada059b54364aa2ffa4a [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<!-- Generated by javadoc (build 1.5.0_06) on Wed Jul 19 14:45:52 EDT 2006 -->
<TITLE>
SQLTemplate (Apache Cayenne API Documentation - v.2.0-incubating-SNAPSHOT)
</TITLE>
<META NAME="keywords" CONTENT="org.apache.cayenne.query.SQLTemplate class">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../apache-javadoc.css" TITLE="Style">
<SCRIPT type="text/javascript">
function windowTitle()
{
parent.document.title="SQLTemplate (Apache Cayenne API Documentation - v.2.0-incubating-SNAPSHOT)";
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>
</HEAD>
<BODY BGCOLOR="white" onload="windowTitle();">
<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
<TR ALIGN="center" VALIGN="top">
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../org/apache/cayenne/query/SQLActionVisitor.html" title="interface in org.apache.cayenne.query"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../org/apache/cayenne/query/UpdateBatchQuery.html" title="class in org.apache.cayenne.query"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../index.html?org/apache/cayenne/query/SQLTemplate.html" target="_top"><B>FRAMES</B></A> &nbsp;
&nbsp;<A HREF="SQLTemplate.html" target="_top"><B>NO FRAMES</B></A> &nbsp;
&nbsp;<SCRIPT type="text/javascript">
<!--
if(window==top) {
document.writeln('<A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>');
}
//-->
</SCRIPT>
<NOSCRIPT>
<A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>
</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;<A HREF="#field_summary">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;<A HREF="#field_detail">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->
<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
org.apache.cayenne.query</FONT>
<BR>
Class SQLTemplate</H2>
<PRE>
java.lang.Object
<IMG SRC="../../../../resources/inherit.gif" ALT="extended by "><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html" title="class in org.apache.cayenne.query">org.apache.cayenne.query.AbstractQuery</A>
<IMG SRC="../../../../resources/inherit.gif" ALT="extended by "><B>org.apache.cayenne.query.SQLTemplate</B>
</PRE>
<DL>
<DT><B>All Implemented Interfaces:</B> <DD>java.io.Serializable, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A>, <A HREF="../../../../org/apache/cayenne/query/ParameterizedQuery.html" title="interface in org.apache.cayenne.query">ParameterizedQuery</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A>, <A HREF="../../../../org/apache/cayenne/util/XMLSerializable.html" title="interface in org.apache.cayenne.util">XMLSerializable</A></DD>
</DL>
<DL>
<DT><B>Direct Known Subclasses:</B> <DD><A HREF="../../../../org/apache/cayenne/wocompat/EOSQLQuery.html" title="class in org.apache.cayenne.wocompat">EOSQLQuery</A></DD>
</DL>
<HR>
<DL>
<DT><PRE>public class <B>SQLTemplate</B><DT>extends <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</A><DT>implements <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A>, <A HREF="../../../../org/apache/cayenne/query/ParameterizedQuery.html" title="interface in org.apache.cayenne.query">ParameterizedQuery</A>, <A HREF="../../../../org/apache/cayenne/util/XMLSerializable.html" title="interface in org.apache.cayenne.util">XMLSerializable</A></DL>
</PRE>
<P>
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="../../../../org/apache/cayenne/query/SQLTemplate.html#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>
<h3>Parameter Sets</h3>
<p>
SQLTemplate supports multiple sets of parameters, so a single query can be executed
multiple times with different parameters. "Scrolling" through parameter list is done by
calling <A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#parametersIterator()"><CODE>parametersIterator()</CODE></A>. This iterator goes over parameter sets,
returning a Map on each call to "next()"
</p>
<P>
<P>
<DL>
<DT><B>Since:</B></DT>
<DD>1.1</DD>
<DT><B>Author:</B></DT>
<DD>Andrus Adamchik</DD>
<DT><B>See Also:</B><DD><A HREF="../../../../serialized-form.html#org.apache.cayenne.query.SQLTemplate">Serialized Form</A></DL>
<HR>
<P>
<!-- =========== FIELD SUMMARY =========== -->
<A NAME="field_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Field Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#defaultTemplate">defaultTemplate</A></B></CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;java.util.Map[]</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#parameters">parameters</A></B></CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#selecting">selecting</A></B></CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 this property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;java.util.Map</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#templates">templates</A></B></CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
</TABLE>
&nbsp;<A NAME="fields_inherited_from_class_org.apache.cayenne.query.AbstractQuery"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Fields inherited from class org.apache.cayenne.query.<A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#name">name</A>, <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#root">root</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="fields_inherited_from_class_org.apache.cayenne.query.GenericSelectQuery"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Fields inherited from interface org.apache.cayenne.query.<A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#CACHE_POLICY_DEFAULT">CACHE_POLICY_DEFAULT</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#CACHE_POLICY_PROPERTY">CACHE_POLICY_PROPERTY</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#FETCH_LIMIT_DEFAULT">FETCH_LIMIT_DEFAULT</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#FETCH_LIMIT_PROPERTY">FETCH_LIMIT_PROPERTY</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#FETCHING_DATA_ROWS_DEFAULT">FETCHING_DATA_ROWS_DEFAULT</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#FETCHING_DATA_ROWS_PROPERTY">FETCHING_DATA_ROWS_PROPERTY</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#LOCAL_CACHE">LOCAL_CACHE</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#NO_CACHE">NO_CACHE</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#PAGE_SIZE_DEFAULT">PAGE_SIZE_DEFAULT</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#PAGE_SIZE_PROPERTY">PAGE_SIZE_PROPERTY</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#REFRESHING_OBJECTS_DEFAULT">REFRESHING_OBJECTS_DEFAULT</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#REFRESHING_OBJECTS_PROPERTY">REFRESHING_OBJECTS_PROPERTY</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#RESOLVING_INHERITED_DEFAULT">RESOLVING_INHERITED_DEFAULT</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#RESOLVING_INHERITED_PROPERTY">RESOLVING_INHERITED_PROPERTY</A>, <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#SHARED_CACHE">SHARED_CACHE</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<A NAME="constructor_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Constructor Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate()">SQLTemplate</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates an empty SQLTemplate.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(boolean)">SQLTemplate</A></B>(boolean&nbsp;selecting)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(java.lang.Class, java.lang.String)">SQLTemplate</A></B>(java.lang.Class&nbsp;rootClass,
java.lang.String&nbsp;defaultTemplate)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(java.lang.Class, java.lang.String, boolean)">SQLTemplate</A></B>(java.lang.Class&nbsp;rootClass,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(org.apache.cayenne.map.DataMap, java.lang.String)">SQLTemplate</A></B>(<A HREF="../../../../org/apache/cayenne/map/DataMap.html" title="class in org.apache.cayenne.map">DataMap</A>&nbsp;rootMap,
java.lang.String&nbsp;defaultTemplate)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(org.apache.cayenne.map.DataMap, java.lang.String, boolean)">SQLTemplate</A></B>(<A HREF="../../../../org/apache/cayenne/map/DataMap.html" title="class in org.apache.cayenne.map">DataMap</A>&nbsp;rootMap,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(org.apache.cayenne.map.DbEntity, java.lang.String)">SQLTemplate</A></B>(<A HREF="../../../../org/apache/cayenne/map/DbEntity.html" title="class in org.apache.cayenne.map">DbEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(org.apache.cayenne.map.DbEntity, java.lang.String, boolean)">SQLTemplate</A></B>(<A HREF="../../../../org/apache/cayenne/map/DbEntity.html" title="class in org.apache.cayenne.map">DbEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(org.apache.cayenne.map.ObjEntity, java.lang.String)">SQLTemplate</A></B>(<A HREF="../../../../org/apache/cayenne/map/ObjEntity.html" title="class in org.apache.cayenne.map">ObjEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(org.apache.cayenne.map.ObjEntity, java.lang.String, boolean)">SQLTemplate</A></B>(<A HREF="../../../../org/apache/cayenne/map/ObjEntity.html" title="class in org.apache.cayenne.map">ObjEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(java.lang.String, java.lang.String)">SQLTemplate</A></B>(java.lang.String&nbsp;objEntityName,
java.lang.String&nbsp;defaultTemplate)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#SQLTemplate(java.lang.String, java.lang.String, boolean)">SQLTemplate</A></B>(java.lang.String&nbsp;objEntityName,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
</TABLE>
&nbsp;
<!-- ========== METHOD SUMMARY =========== -->
<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Method Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#addPrefetch(java.lang.String)">addPrefetch</A></B>(java.lang.String&nbsp;prefetchPath)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Adds a prefetch.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#addPrefetches(java.util.Collection)">addPrefetches</A></B>(java.util.Collection&nbsp;prefetches)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Adds all prefetches from a provided collection.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#clearPrefetches()">clearPrefetches</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Clears all prefetches.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#createQuery(java.util.Map)">createQuery</A></B>(java.util.Map&nbsp;parameters)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates and returns a new SQLTemplate built using this query as a prototype and
substituting template parameters with the values from the map.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/SQLAction.html" title="interface in org.apache.cayenne.query">SQLAction</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</A></B>(<A HREF="../../../../org/apache/cayenne/query/SQLActionVisitor.html" title="interface in org.apache.cayenne.query">SQLActionVisitor</A>&nbsp;visitor)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Calls <em>sqlAction(this)</em> on the visitor.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#encodeAsXML(org.apache.cayenne.util.XMLEncoder)">encodeAsXML</A></B>(<A HREF="../../../../org/apache/cayenne/util/XMLEncoder.html" title="class in org.apache.cayenne.util">XMLEncoder</A>&nbsp;encoder)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Prints itself as XML to the provided PrintWriter.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getCachePolicy()">getCachePolicy</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns query cache policy, which can be one of <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#NO_CACHE"><CODE>GenericSelectQuery.NO_CACHE</CODE></A>,
<A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#LOCAL_CACHE"><CODE>GenericSelectQuery.LOCAL_CACHE</CODE></A>, or <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#SHARED_CACHE"><CODE>GenericSelectQuery.SHARED_CACHE</CODE></A>.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getCustomTemplate(java.lang.String)">getCustomTemplate</A></B>(java.lang.String&nbsp;key)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns template for key, or null if there is no template configured for this key.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getDefaultTemplate()">getDefaultTemplate</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns default SQL template for this query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getFetchLimit()">getFetchLimit</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the limit on the maximium number of records that can be returned by this
query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/QueryMetadata.html" title="interface in org.apache.cayenne.query">QueryMetadata</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</A></B>(<A HREF="../../../../org/apache/cayenne/map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</A>&nbsp;resolver)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns default select parameters.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getPageSize()">getPageSize</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns query page size.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.util.Map</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getParameters()">getParameters</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Utility method to get the first set of parameters, since most queries will only
have one.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getPrefetchTree()">getPrefetchTree</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns a root node of prefetch tree used by this query, or null of no prefetches
are configured.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getTemplate(java.lang.String)">getTemplate</A></B>(java.lang.String&nbsp;key)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns a template for key, or a default template if a template for key is not
found.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.util.Collection</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#getTemplateKeys()">getTemplateKeys</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns a collection of configured template keys.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#initWithProperties(java.util.Map)">initWithProperties</A></B>(java.util.Map&nbsp;properties)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Initializes query parameters using a set of properties.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#isFetchingDataRows()">isFetchingDataRows</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns <code>true</code> if this query should produce a list of data rows as
opposed to DataObjects, <code>false</code> for DataObjects.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#isRefreshingObjects()">isRefreshingObjects</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns <code>true</code> if the query results should replace any currently
cached values, returns <code>false</code> otherwise.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#isResolvingInherited()">isResolvingInherited</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns true if objects fetched via this query should be fully resolved according
to the inheritance hierarchy.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#isSelecting()">isSelecting</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.util.Iterator</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#parametersIterator()">parametersIterator</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns an iterator over parameter sets.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#parametersSize()">parametersSize</A></B>()</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the number of parameter sets.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html" title="class in org.apache.cayenne.query">SQLTemplate</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#queryWithParameters(java.util.Map)">queryWithParameters</A></B>(java.util.Map&nbsp;parameters)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns a new query built using this query as a prototype and a new set of
parameters.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html" title="class in org.apache.cayenne.query">SQLTemplate</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#queryWithParameters(java.util.Map[])">queryWithParameters</A></B>(java.util.Map[]&nbsp;parameters)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns a new query built using this query as a prototype and a new set of
parameters.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#removePrefetch(java.lang.String)">removePrefetch</A></B>(java.lang.String&nbsp;prefetch)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#removeTemplate(java.lang.String)">removeTemplate</A></B>(java.lang.String&nbsp;key)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setCachePolicy(java.lang.String)">setCachePolicy</A></B>(java.lang.String&nbsp;policy)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setDefaultTemplate(java.lang.String)">setDefaultTemplate</A></B>(java.lang.String&nbsp;string)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets default SQL template for this query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setFetchingDataRows(boolean)">setFetchingDataRows</A></B>(boolean&nbsp;flag)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setFetchLimit(int)">setFetchLimit</A></B>(int&nbsp;fetchLimit)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setPageSize(int)">setPageSize</A></B>(int&nbsp;pageSize)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setParameters(java.util.Map)">setParameters</A></B>(java.util.Map&nbsp;map)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Utility method to initialize query with only a single set of parameters.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setParameters(java.util.Map[])">setParameters</A></B>(java.util.Map[]&nbsp;parameters)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setRefreshingObjects(boolean)">setRefreshingObjects</A></B>(boolean&nbsp;flag)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setResolvingInherited(boolean)">setResolvingInherited</A></B>(boolean&nbsp;b)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setSelecting(boolean)">setSelecting</A></B>(boolean&nbsp;b)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setTemplate(java.lang.String, java.lang.String)">setTemplate</A></B>(java.lang.String&nbsp;key,
java.lang.String&nbsp;template)</CODE>
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Adds a SQL template string for a given key.</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.apache.cayenne.query.AbstractQuery"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from class org.apache.cayenne.query.<A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#getName()">getName</A>, <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#getRoot()">getRoot</A>, <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#route(org.apache.cayenne.query.QueryRouter, org.apache.cayenne.map.EntityResolver, org.apache.cayenne.query.Query)">route</A>, <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#setName(java.lang.String)">setName</A>, <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#setRoot(java.lang.Object)">setRoot</A>, <A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#toString()">toString</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.apache.cayenne.query.Query"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from interface org.apache.cayenne.query.<A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/apache/cayenne/query/Query.html#getName()">getName</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#getRoot()">getRoot</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#route(org.apache.cayenne.query.QueryRouter, org.apache.cayenne.map.EntityResolver, org.apache.cayenne.query.Query)">route</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#setName(java.lang.String)">setName</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#setRoot(java.lang.Object)">setRoot</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.apache.cayenne.query.Query"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from interface org.apache.cayenne.query.<A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/apache/cayenne/query/Query.html#getName()">getName</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#getRoot()">getRoot</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#route(org.apache.cayenne.query.QueryRouter, org.apache.cayenne.map.EntityResolver, org.apache.cayenne.query.Query)">route</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#setName(java.lang.String)">setName</A>, <A HREF="../../../../org/apache/cayenne/query/Query.html#setRoot(java.lang.Object)">setRoot</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>
<!-- ============ FIELD DETAIL =========== -->
<A NAME="field_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Field Detail</B></FONT></TH>
</TR>
</TABLE>
<A NAME="defaultTemplate"><!-- --></A><H3>
defaultTemplate</H3>
<PRE>
protected java.lang.String <B>defaultTemplate</B></PRE>
<DL>
<DL>
</DL>
</DL>
<HR>
<A NAME="templates"><!-- --></A><H3>
templates</H3>
<PRE>
protected java.util.Map <B>templates</B></PRE>
<DL>
<DL>
</DL>
</DL>
<HR>
<A NAME="parameters"><!-- --></A><H3>
parameters</H3>
<PRE>
protected java.util.Map[] <B>parameters</B></PRE>
<DL>
<DL>
</DL>
</DL>
<HR>
<A NAME="selecting"><!-- --></A><H3>
selecting</H3>
<PRE>
protected boolean <B>selecting</B></PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 this property is redundant.</I><DL>
</DL>
</DL>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<A NAME="constructor_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TH>
</TR>
</TABLE>
<A NAME="SQLTemplate()"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>()</PRE>
<DL>
<DD>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.
<P>
<DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DL>
<HR>
<A NAME="SQLTemplate(org.apache.cayenne.map.DataMap, java.lang.String)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(<A HREF="../../../../org/apache/cayenne/map/DataMap.html" title="class in org.apache.cayenne.map">DataMap</A>&nbsp;rootMap,
java.lang.String&nbsp;defaultTemplate)</PRE>
<DL>
<DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DL>
<HR>
<A NAME="SQLTemplate(org.apache.cayenne.map.ObjEntity, java.lang.String)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(<A HREF="../../../../org/apache/cayenne/map/ObjEntity.html" title="class in org.apache.cayenne.map">ObjEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate)</PRE>
<DL>
<DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DL>
<HR>
<A NAME="SQLTemplate(java.lang.Class, java.lang.String)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(java.lang.Class&nbsp;rootClass,
java.lang.String&nbsp;defaultTemplate)</PRE>
<DL>
<DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DL>
<HR>
<A NAME="SQLTemplate(org.apache.cayenne.map.DbEntity, java.lang.String)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(<A HREF="../../../../org/apache/cayenne/map/DbEntity.html" title="class in org.apache.cayenne.map">DbEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate)</PRE>
<DL>
<DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DL>
<HR>
<A NAME="SQLTemplate(java.lang.String, java.lang.String)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(java.lang.String&nbsp;objEntityName,
java.lang.String&nbsp;defaultTemplate)</PRE>
<DL>
<DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DL>
<HR>
<A NAME="SQLTemplate(boolean)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(boolean&nbsp;selecting)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
<DD>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.
<P>
</DL>
<HR>
<A NAME="SQLTemplate(org.apache.cayenne.map.DataMap, java.lang.String, boolean)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(<A HREF="../../../../org/apache/cayenne/map/DataMap.html" title="class in org.apache.cayenne.map">DataMap</A>&nbsp;rootMap,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
</DL>
<HR>
<A NAME="SQLTemplate(org.apache.cayenne.map.ObjEntity, java.lang.String, boolean)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(<A HREF="../../../../org/apache/cayenne/map/ObjEntity.html" title="class in org.apache.cayenne.map">ObjEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
</DL>
<HR>
<A NAME="SQLTemplate(java.lang.Class, java.lang.String, boolean)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(java.lang.Class&nbsp;rootClass,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
</DL>
<HR>
<A NAME="SQLTemplate(org.apache.cayenne.map.DbEntity, java.lang.String, boolean)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(<A HREF="../../../../org/apache/cayenne/map/DbEntity.html" title="class in org.apache.cayenne.map">DbEntity</A>&nbsp;rootEntity,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
</DL>
<HR>
<A NAME="SQLTemplate(java.lang.String, java.lang.String, boolean)"><!-- --></A><H3>
SQLTemplate</H3>
<PRE>
public <B>SQLTemplate</B>(java.lang.String&nbsp;objEntityName,
java.lang.String&nbsp;defaultTemplate,
boolean&nbsp;selecting)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
</DL>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Method Detail</B></FONT></TH>
</TR>
</TABLE>
<A NAME="getMetaData(org.apache.cayenne.map.EntityResolver)"><!-- --></A><H3>
getMetaData</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/QueryMetadata.html" title="interface in org.apache.cayenne.query">QueryMetadata</A> <B>getMetaData</B>(<A HREF="../../../../org/apache/cayenne/map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</A>&nbsp;resolver)</PRE>
<DL>
<DD><B>Description copied from class: <CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#getMetaData(org.apache.cayenne.map.EntityResolver)">AbstractQuery</A></CODE></B></DD>
<DD>Returns default select parameters.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/Query.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A></CODE><DT><B>Overrides:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</A></CODE> in class <CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="createSQLAction(org.apache.cayenne.query.SQLActionVisitor)"><!-- --></A><H3>
createSQLAction</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/SQLAction.html" title="interface in org.apache.cayenne.query">SQLAction</A> <B>createSQLAction</B>(<A HREF="../../../../org/apache/cayenne/query/SQLActionVisitor.html" title="interface in org.apache.cayenne.query">SQLActionVisitor</A>&nbsp;visitor)</PRE>
<DL>
<DD>Calls <em>sqlAction(this)</em> on the visitor.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/Query.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A></CODE><DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</A></CODE> in class <CODE><A HREF="../../../../org/apache/cayenne/query/AbstractQuery.html" title="class in org.apache.cayenne.query">AbstractQuery</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="encodeAsXML(org.apache.cayenne.util.XMLEncoder)"><!-- --></A><H3>
encodeAsXML</H3>
<PRE>
public void <B>encodeAsXML</B>(<A HREF="../../../../org/apache/cayenne/util/XMLEncoder.html" title="class in org.apache.cayenne.util">XMLEncoder</A>&nbsp;encoder)</PRE>
<DL>
<DD>Prints itself as XML to the provided PrintWriter.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/util/XMLSerializable.html#encodeAsXML(org.apache.cayenne.util.XMLEncoder)">encodeAsXML</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/util/XMLSerializable.html" title="interface in org.apache.cayenne.util">XMLSerializable</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.1</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="initWithProperties(java.util.Map)"><!-- --></A><H3>
initWithProperties</H3>
<PRE>
public void <B>initWithProperties</B>(java.util.Map&nbsp;properties)</PRE>
<DL>
<DD>Initializes query parameters using a set of properties.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.1</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="parametersIterator()"><!-- --></A><H3>
parametersIterator</H3>
<PRE>
public java.util.Iterator <B>parametersIterator</B>()</PRE>
<DL>
<DD>Returns an iterator over parameter sets. Each element returned from the iterator is
a java.util.Map.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="parametersSize()"><!-- --></A><H3>
parametersSize</H3>
<PRE>
public int <B>parametersSize</B>()</PRE>
<DL>
<DD>Returns the number of parameter sets.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="queryWithParameters(java.util.Map)"><!-- --></A><H3>
queryWithParameters</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html" title="class in org.apache.cayenne.query">SQLTemplate</A> <B>queryWithParameters</B>(java.util.Map&nbsp;parameters)</PRE>
<DL>
<DD>Returns a new query built using this query as a prototype and a new set of
parameters.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="queryWithParameters(java.util.Map[])"><!-- --></A><H3>
queryWithParameters</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html" title="class in org.apache.cayenne.query">SQLTemplate</A> <B>queryWithParameters</B>(java.util.Map[]&nbsp;parameters)</PRE>
<DL>
<DD>Returns a new query built using this query as a prototype and a new set of
parameters.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="createQuery(java.util.Map)"><!-- --></A><H3>
createQuery</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/Query.html" title="interface in org.apache.cayenne.query">Query</A> <B>createQuery</B>(java.util.Map&nbsp;parameters)</PRE>
<DL>
<DD>Creates and returns a new SQLTemplate built using this query as a prototype and
substituting template parameters with the values from the map.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/ParameterizedQuery.html#createQuery(java.util.Map)">createQuery</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/ParameterizedQuery.html" title="interface in org.apache.cayenne.query">ParameterizedQuery</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.1</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="getCachePolicy()"><!-- --></A><H3>
getCachePolicy</H3>
<PRE>
public java.lang.String <B>getCachePolicy</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getCachePolicy()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns query cache policy, which can be one of <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#NO_CACHE"><CODE>GenericSelectQuery.NO_CACHE</CODE></A>,
<A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#LOCAL_CACHE"><CODE>GenericSelectQuery.LOCAL_CACHE</CODE></A>, or <A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#SHARED_CACHE"><CODE>GenericSelectQuery.SHARED_CACHE</CODE></A>. NO_CACHE is generally a default
policy.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getCachePolicy()">getCachePolicy</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setCachePolicy(java.lang.String)"><!-- --></A><H3>
setCachePolicy</H3>
<PRE>
public void <B>setCachePolicy</B>(java.lang.String&nbsp;policy)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getFetchLimit()"><!-- --></A><H3>
getFetchLimit</H3>
<PRE>
public int <B>getFetchLimit</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getFetchLimit()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns the limit on the maximium number of records that can be returned by this
query. If the actual number of rows in the result exceeds the fetch limit, they
will be discarded. One possible use of fetch limit is using it as a safeguard
against large result sets that may lead to the application running out of memory,
etc. If a fetch limit is greater or equal to zero, all rows will be returned.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getFetchLimit()">getFetchLimit</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Returns:</B><DD>the limit on the maximium number of records that can be returned by this
query</DL>
</DD>
</DL>
<HR>
<A NAME="setFetchLimit(int)"><!-- --></A><H3>
setFetchLimit</H3>
<PRE>
public void <B>setFetchLimit</B>(int&nbsp;fetchLimit)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getPageSize()"><!-- --></A><H3>
getPageSize</H3>
<PRE>
public int <B>getPageSize</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getPageSize()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns query page size. Page size is a hint to Cayenne that query should be
performed page by page, instead of retrieveing all results at once. If the value
returned is less than or equal to zero, no paging should occur.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getPageSize()">getPageSize</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setPageSize(int)"><!-- --></A><H3>
setPageSize</H3>
<PRE>
public void <B>setPageSize</B>(int&nbsp;pageSize)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setFetchingDataRows(boolean)"><!-- --></A><H3>
setFetchingDataRows</H3>
<PRE>
public void <B>setFetchingDataRows</B>(boolean&nbsp;flag)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="isFetchingDataRows()"><!-- --></A><H3>
isFetchingDataRows</H3>
<PRE>
public boolean <B>isFetchingDataRows</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isFetchingDataRows()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns <code>true</code> if this query should produce a list of data rows as
opposed to DataObjects, <code>false</code> for DataObjects. This is a hint to
QueryEngine executing this query.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isFetchingDataRows()">isFetchingDataRows</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="isRefreshingObjects()"><!-- --></A><H3>
isRefreshingObjects</H3>
<PRE>
public boolean <B>isRefreshingObjects</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isRefreshingObjects()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns <code>true</code> if the query results should replace any currently
cached values, returns <code>false</code> otherwise. If
<A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isFetchingDataRows()"><CODE>GenericSelectQuery.isFetchingDataRows()</CODE></A>returns <code>true</code>, this setting is not
applicable and has no effect.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isRefreshingObjects()">isRefreshingObjects</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setRefreshingObjects(boolean)"><!-- --></A><H3>
setRefreshingObjects</H3>
<PRE>
public void <B>setRefreshingObjects</B>(boolean&nbsp;flag)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="isResolvingInherited()"><!-- --></A><H3>
isResolvingInherited</H3>
<PRE>
public boolean <B>isResolvingInherited</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isResolvingInherited()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns true if objects fetched via this query should be fully resolved according
to the inheritance hierarchy.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#isResolvingInherited()">isResolvingInherited</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setResolvingInherited(boolean)"><!-- --></A><H3>
setResolvingInherited</H3>
<PRE>
public void <B>setResolvingInherited</B>(boolean&nbsp;b)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getDefaultTemplate()"><!-- --></A><H3>
getDefaultTemplate</H3>
<PRE>
public java.lang.String <B>getDefaultTemplate</B>()</PRE>
<DL>
<DD>Returns default SQL template for this query.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setDefaultTemplate(java.lang.String)"><!-- --></A><H3>
setDefaultTemplate</H3>
<PRE>
public void <B>setDefaultTemplate</B>(java.lang.String&nbsp;string)</PRE>
<DL>
<DD>Sets default SQL template for this query.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getTemplate(java.lang.String)"><!-- --></A><H3>
getTemplate</H3>
<PRE>
public java.lang.String <B>getTemplate</B>(java.lang.String&nbsp;key)</PRE>
<DL>
<DD>Returns a template for key, or a default template if a template for key is not
found.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getCustomTemplate(java.lang.String)"><!-- --></A><H3>
getCustomTemplate</H3>
<PRE>
public java.lang.String <B>getCustomTemplate</B>(java.lang.String&nbsp;key)</PRE>
<DL>
<DD>Returns template for key, or null if there is no template configured for this key.
Unlike <A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#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.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setTemplate(java.lang.String, java.lang.String)"><!-- --></A><H3>
setTemplate</H3>
<PRE>
public void <B>setTemplate</B>(java.lang.String&nbsp;key,
java.lang.String&nbsp;template)</PRE>
<DL>
<DD>Adds a SQL template string for a given key.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setDefaultTemplate(java.lang.String)"><CODE>setDefaultTemplate(String)</CODE></A></DL>
</DD>
</DL>
<HR>
<A NAME="removeTemplate(java.lang.String)"><!-- --></A><H3>
removeTemplate</H3>
<PRE>
public void <B>removeTemplate</B>(java.lang.String&nbsp;key)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getTemplateKeys()"><!-- --></A><H3>
getTemplateKeys</H3>
<PRE>
public java.util.Collection <B>getTemplateKeys</B>()</PRE>
<DL>
<DD>Returns a collection of configured template keys.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getParameters()"><!-- --></A><H3>
getParameters</H3>
<PRE>
public java.util.Map <B>getParameters</B>()</PRE>
<DL>
<DD>Utility method to get the first set of parameters, since most queries will only
have one.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setParameters(java.util.Map)"><!-- --></A><H3>
setParameters</H3>
<PRE>
public void <B>setParameters</B>(java.util.Map&nbsp;map)</PRE>
<DL>
<DD>Utility method to initialize query with only a single set of parameters. Useful,
since most queries will only have one set. Internally calls
<A HREF="../../../../org/apache/cayenne/query/SQLTemplate.html#setParameters(java.util.Map[])"><CODE>setParameters(Map[])</CODE></A>.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setParameters(java.util.Map[])"><!-- --></A><H3>
setParameters</H3>
<PRE>
public void <B>setParameters</B>(java.util.Map[]&nbsp;parameters)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="isSelecting()"><!-- --></A><H3>
isSelecting</H3>
<PRE>
public boolean <B>isSelecting</B>()</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
<DD>Returns true if SQLTemplate is expected to return a ResultSet.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="setSelecting(boolean)"><!-- --></A><H3>
setSelecting</H3>
<PRE>
public void <B>setSelecting</B>(boolean&nbsp;b)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Since 1.2 'selecting' property is redundant.</I>
<P>
<DD>Sets whether SQLTemplate is expected to return a ResultSet.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="getPrefetchTree()"><!-- --></A><H3>
getPrefetchTree</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</A> <B>getPrefetchTree</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getPrefetchTree()">GenericSelectQuery</A></CODE></B></DD>
<DD>Returns a root node of prefetch tree used by this query, or null of no prefetches
are configured.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html#getPrefetchTree()">getPrefetchTree</A></CODE> in interface <CODE><A HREF="../../../../org/apache/cayenne/query/GenericSelectQuery.html" title="interface in org.apache.cayenne.query">GenericSelectQuery</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="addPrefetch(java.lang.String)"><!-- --></A><H3>
addPrefetch</H3>
<PRE>
public <A HREF="../../../../org/apache/cayenne/query/PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</A> <B>addPrefetch</B>(java.lang.String&nbsp;prefetchPath)</PRE>
<DL>
<DD>Adds a prefetch.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="removePrefetch(java.lang.String)"><!-- --></A><H3>
removePrefetch</H3>
<PRE>
public void <B>removePrefetch</B>(java.lang.String&nbsp;prefetch)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="addPrefetches(java.util.Collection)"><!-- --></A><H3>
addPrefetches</H3>
<PRE>
public void <B>addPrefetches</B>(java.util.Collection&nbsp;prefetches)</PRE>
<DL>
<DD>Adds all prefetches from a provided collection.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<HR>
<A NAME="clearPrefetches()"><!-- --></A><H3>
clearPrefetches</H3>
<PRE>
public void <B>clearPrefetches</B>()</PRE>
<DL>
<DD>Clears all prefetches.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Since:</B></DT>
<DD>1.2</DD>
</DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
<TR ALIGN="center" VALIGN="top">
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../org/apache/cayenne/query/SQLActionVisitor.html" title="interface in org.apache.cayenne.query"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../org/apache/cayenne/query/UpdateBatchQuery.html" title="class in org.apache.cayenne.query"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../index.html?org/apache/cayenne/query/SQLTemplate.html" target="_top"><B>FRAMES</B></A> &nbsp;
&nbsp;<A HREF="SQLTemplate.html" target="_top"><B>NO FRAMES</B></A> &nbsp;
&nbsp;<SCRIPT type="text/javascript">
<!--
if(window==top) {
document.writeln('<A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>');
}
//-->
</SCRIPT>
<NOSCRIPT>
<A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>
</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;<A HREF="#field_summary">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;<A HREF="#field_detail">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<HR>
<i>Copyright &#169; 2001-2006 <a href=
"http://apache.org" target="_top">Apache.org</a> All Rights Reserved.</i>
</BODY>
</HTML>