Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/ObjectIdQuery/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/ObjectIdQuery/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/ObjectIdQuery/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/ObjectIdQuery/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -65,6 +65,7 @@ <p>Normally if you need to find an object that matches a certain primary key value, you would use <tt>DataObjectUtils.objectForPK(DataContext,String,int)</tt>. This method will look up an object in the cache, and only run a query if it is not yet cached. <tt>ObjectIdQuery</tt> gives the user more control of the object caching behavior. It supports three possible caching policies:</p> +<div class='table-wrap'> <table class='confluenceTable'><tbody> <tr> <th class='confluenceTh'>Policy</th> @@ -83,6 +84,8 @@ <td class='confluenceTd'>This policy suppresses database fetch. If an object is already cached (either at the DataContext or DataDomain level), query returns this object. Otherwise it returns an empty result.</td> </tr> </tbody></table> +</div> + <p>An example of getting a guranteed fresh object:</p> @@ -118,7 +121,7 @@ Artist object = (Artist) DataObjectUtils <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body>
Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/Queries Stored in DataMap/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/Queries%20Stored%20in%20DataMap/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/Queries Stored in DataMap/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/Queries Stored in DataMap/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -95,7 +95,7 @@ SelectQuery query = prototype.queryWithP <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/QueryChain/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/QueryChain/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/QueryChain/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/QueryChain/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -78,7 +78,7 @@ context.performNonSelectingQuery(query); <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/RelationshipQuery/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/RelationshipQuery/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/RelationshipQuery/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/RelationshipQuery/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -74,7 +74,7 @@ List paintings = context.performQuery(qu <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/Advanced SQLTemplate/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SQLTemplate%20Query/Advanced%20SQLTemplate/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/Advanced SQLTemplate/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/Advanced SQLTemplate/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -119,7 +119,7 @@ List objects = context.performQuery(quer <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/SQLTemplate Basics/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SQLTemplate%20Query/SQLTemplate%20Basics/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/SQLTemplate Basics/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/SQLTemplate Basics/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -130,7 +130,7 @@ query.setTemplate(PostgresAdapter.class. <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/SQLTemplate Result Mapping/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SQLTemplate%20Query/SQLTemplate%20Result%20Mapping/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/SQLTemplate Result Mapping/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/SQLTemplate Result Mapping/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -83,7 +83,7 @@ <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> <pre class="code-java">SQLTemplate query = <span class="code-keyword">new</span> SQLTemplate(Artist.class, <span class="code-quote">"SELECT * FROM ARTIST"</span>); -<span class="code-comment">// *** Force DataRows +<span class="code-comment">// Force DataRows </span>query.setFetchingDataRows(<span class="code-keyword">true</span>); <span class="code-comment">// List of DataRow @@ -92,15 +92,15 @@ <h3><a name="SQLTemplateResultMapping-ScalarResults"></a>Scalar Results</h3> -<p>To select a list of scalar values, you will need to use a SQLResultSetMapping class to tell Cayenne how to deal with it:</p> +<p>To select a list of scalar values, you will need to use a <tt>SQLResult</tt> class to tell Cayenne how to deal with it:</p> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> <pre class="code-java">SQLTemplate query = <span class="code-keyword">new</span> SQLTemplate(Painting.class, <span class="code-quote">"SELECT ESTIMATED_PRICE P FROM PAINTING"</span>); <span class="code-comment">// *** let Cayenne know that result is a scalar -</span>SQLResultSetMapping rsMap = <span class="code-keyword">new</span> SQLResultSetMapping(); -rsMap.addColumnResult(<span class="code-quote">"P"</span>); -query.setResultSetMapping(rsMap); +</span>SQLResult resultDescriptor = <span class="code-keyword">new</span> SQLResult(); +resultDescriptor.addColumnResult(<span class="code-quote">"P"</span>); +query.setResult(resultDescriptor); <span class="code-comment">// List of <span class="code-object">Number</span>'s </span>List prices = context.performQuery(query);</pre> @@ -112,9 +112,9 @@ query.setResultSetMapping(rsMap); <pre class="code-java">SQLTemplate query = <span class="code-keyword">new</span> SQLTemplate(Painting.class, <span class="code-quote">"SELECT SUM(ESTIMATED_PRICE) S FROM PAINTING"</span>); <span class="code-comment">// *** let Cayenne know that result is a scalar -</span>SQLResultSetMapping rsMap = <span class="code-keyword">new</span> SQLResultSetMapping(); -rsMap.addColumnResult(<span class="code-quote">"S"</span>); -query.setResultSetMapping(rsMap); +</span>SQLResult resultDescriptor = <span class="code-keyword">new</span> SQLResult(); +resultDescriptor.addColumnResult(<span class="code-quote">"S"</span>); +query.setResult(resultDescriptor); <span class="code-comment">// List of <span class="code-object">Number</span>'s </span><span class="code-object">Number</span> assetsValue = (<span class="code-object">Number</span>) DataObjectUtils.objectForQuery(context, query)</pre> @@ -122,7 +122,7 @@ query.setResultSetMapping(rsMap); <h3><a name="SQLTemplateResultMapping-MixedResults"></a>Mixed Results</h3> -<p>SQLResultSetMapping can be used to fetch a mix of objects and scalars. In this case the result will be <tt>Object[]</tt> that contains scalars and objects in the order they were configured in SQLResultSetMapping:</p> +<p><tt>SQLResult</tt> can be used to fetch a mix of objects and scalars. In this case the result will be <tt>Object[]</tt> that contains scalars and objects in the order they were configured in SQLResultSetMapping:</p> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> <pre class="code-java">SQLTemplate query = <span class="code-keyword">new</span> SQLTemplate(Artist.class, <span class="code-quote">"SELECT t0.ARTIST_ID, t0.NAME, t0.DATE_OF_BIRTH, COUNT(t1.PAINTING_ID) C "</span> + @@ -135,10 +135,10 @@ artistResult.addDbField(Artist.ARTIST_ID artistResult.addObjectField(Artist.NAME_PROPERTY, <span class="code-quote">"NAME"</span>); artistResult.addObjectField(Artist.DATE_OF_BIRTH_PROPERTY, <span class="code-quote">"DATE_OF_BIRTH"</span>); -SQLResultSetMapping rsMap = <span class="code-keyword">new</span> SQLResultSetMapping(); -rsMap.addEntityResult(artistResult); -rsMap.addColumnResult(<span class="code-quote">"C"</span>); -query.setResultSetMapping(rsMap); +SQLResult resultDescriptor = <span class="code-keyword">new</span> SQLResult(); +resultDescriptor.addEntityResult(artistResult); +resultDescriptor.addColumnResult(<span class="code-quote">"C"</span>); +query.setResult(resultDescriptor); <span class="code-comment">// List of <span class="code-object">Object</span>[] </span><span class="code-object">Number</span> assetsValue = (<span class="code-object">Number</span>) DataObjectUtils.objectForQuery(context, query)</pre> @@ -149,7 +149,7 @@ query.setResultSetMapping(rsMap); <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/Scripting SQLTemplate/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SQLTemplate%20Query/Scripting%20SQLTemplate/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/Scripting SQLTemplate/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/Scripting SQLTemplate/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -69,7 +69,7 @@ </div> <div id="ConfluenceContent"><p>SQLTemplate's internal SQL string is a dynamic script that is processed at runtime to generate PreparedStatement SQL code. Dynamic nature of SQLTemplate makes possible a few important things - it allows to bind parameters on the fly; it provides a way to pass extra information to Cayenne that is not included in the SQL text; it supports including/excluding chunks of SQL depending on runtime parameters.</p> -<p>Scripting of SQL strings is done using <a href="http://velocity.apache.org"; rel="nofollow">Apache Velocity</a>. Velocity was chosen primarily for its concise template language (no XML tags within SQL!) that doesn't conflict with the SQL syntax. When creating dynamic SQL template, all standard Velocity directives are available, including <tt>#set</tt>, <tt>#foreach</tt>, <tt>#if</tt>. However due to the nature of the SQL and the need to integrate it with Cayenne runtime, only a few Cayenne custom directives are normally used. These directives (<tt>#bind</tt>..., <tt>#result</tt>, <tt>#chain</tt>, <tt>#chunk</tt>) are described below.</p> +<p>Scripting of SQL strings is done using <a href="http://velocity.apache.org"; class="external-link" rel="nofollow">Apache Velocity</a>. Velocity was chosen primarily for its concise template language (no XML tags within SQL!) that doesn't conflict with the SQL syntax. When creating dynamic SQL template, all standard Velocity directives are available, including <tt>#set</tt>, <tt>#foreach</tt>, <tt>#if</tt>. However due to the nature of the SQL and the need to integrate it with Cayenne runtime, only a few Cayenne custom directives are normally used. These directives (<tt>#bind</tt>..., <tt>#result</tt>, <tt>#chain</tt>, <tt>#chunk</tt>) are described below.</p> <div class='panelMacro'><table class='noteMacro'><colgroup><col width='24'><col></colgroup><tr><td valign='top'><img src="../../../../../images/emoticons/warning.gif" width="16" height="16" align="absmiddle" alt="" border="0"></td><td><b>Directive Syntax Note</b><br />Velocity directives start with pound sign (#) and have their parameters separated by space, not comma. E.g. <tt>#bind('SOMESTRING' 'VARCHAR')</tt>.</td></tr></table></div> <h3><a name="ScriptingSQLTemplate-NamedParameters"></a>Named Parameters</h3> @@ -305,7 +305,7 @@ SQLTemplate select = <span class="code-k <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SQLTemplate%20Query/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SQLTemplate Query/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -81,7 +81,7 @@ <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Parameterized Queries/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SelectQuery/Parameterized%20Queries/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Parameterized Queries/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Parameterized Queries/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -149,7 +149,7 @@ SelectQuery query2 = proto.queryWithPara <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Qualifier Expressions/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SelectQuery/Qualifier%20Expressions/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Qualifier Expressions/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Qualifier Expressions/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -91,7 +91,7 @@ <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/SelectQuery Customization/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SelectQuery/SelectQuery%20Customization/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/SelectQuery Customization/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/SelectQuery Customization/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -88,7 +88,7 @@ <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Using Orderings/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SelectQuery/Using%20Orderings/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Using Orderings/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/Using Orderings/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -92,13 +92,6 @@ SelectQuery query = <span class="code-ke </pre> </div></div> -<div class='panelMacro'><table class='infoMacro'><colgroup><col width='24'><col></colgroup><tr><td valign='top'><img src="../../../../../images/emoticons/information.gif" width="16" height="16" align="absmiddle" alt="" border="0"></td><td><b>Legacy Information</b><br /><p>In older versions of Cayenne (3.0M6 and before), the addOrdering() call in the above example would appear as:</p> -<div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> -<pre class="code-java">query.addOrdering(<span class="code-quote">"artistName"</span>, <span class="code-keyword">true</span>); -</pre> -</div></div> -<p>A boolean parameter of true meant to order ascending (false descending).</p></td></tr></table></div> - <p>Orderings also support in-memory sorting of lists of Java Beans (all DataObjects are normally Java Beans, since they has set/get method pairs for all the properties). For instance to sort with a single ordering, the following code might be used:</p> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> @@ -116,13 +109,6 @@ SelectQuery query = <span class="code-ke </pre> </div></div> -<div class='panelMacro'><table class='infoMacro'><colgroup><col width='24'><col></colgroup><tr><td valign='top'><img src="../../../../../images/emoticons/information.gif" width="16" height="16" align="absmiddle" alt="" border="0"></td><td><b>Legacy Information</b><br /><p>In older versions of Cayenne (3.0M6 and before), the Ordering() constructor in the above example would appear as:</p> -<div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> -<pre class="code-java">Ordering ordering = <span class="code-keyword">new</span> Ordering(<span class="code-quote">"artistName"</span>, <span class="code-keyword">true</span>); -</pre> -</div></div> -<p>A boolean parameter of true meant to order ascending (false descending).</p></td></tr></table></div> - <p>If there is a need to sort on more than one object property, multiple Orderings can be passed as a List to a static method <tt>orderList(List, List)</tt>. The cost of adding new Orderings decreases, as the list of objects ends up being sorted by the first Ordering, then, if any two objects are equal for first Ordering, by the second, and so on.</p> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> @@ -145,7 +131,7 @@ orderings.add(<span class="code-keyword" <div style="height: 12px; background-image: url('../../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/SelectQuery/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/SelectQuery/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -70,6 +70,7 @@ <h3><a name="SelectQuery-SelectQueryParts"></a>SelectQuery Parts</h3> <p>A SelectQuery consists of a root object, qualifier expression and orderings list. Here is a logical correspondence of Cayenne SelectQuery parts and SQL constructs:</p> +<div class='table-wrap'> <table class='confluenceTable'><tbody> <tr> <th class='confluenceTh'> Cayenne SelectQuery </th> @@ -92,6 +93,8 @@ <td class='confluenceTd'> no </td> </tr> </tbody></table> +</div> + <p>The only required query part is root. Query root tells Cayenne what kind of objects to fetch. It can be one of the following:</p> <ul> <li><em>(most commonly used)</em> Java class for the type of persistent objects in question.</li> @@ -144,7 +147,7 @@ DataContext ctxt; <span class="code-comm <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Queries/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Queries/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a><ul> @@ -108,7 +108,7 @@ <div style="height: 12px; background-image: url('../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Executing a Stored Procedure/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Stored%20Procedures/Executing%20a%20Stored%20Procedure/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Executing a Stored Procedure/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Executing a Stored Procedure/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a></li> @@ -120,7 +120,7 @@ query.addParam(<span class="code-quote"> <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Selecting Objects/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Stored%20Procedures/Selecting%20Objects/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Selecting Objects/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Selecting Objects/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a></li> @@ -85,7 +85,7 @@ query.addParam(<span class="code-quote"> <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Stored Procedures and Transactions/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Stored%20Procedures/Stored%20Procedures%20and%20Transactions/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Stored Procedures and Transactions/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/Stored Procedures and Transactions/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a></li> @@ -61,7 +61,7 @@ There maybe a situations when stored pro <div style="height: 12px; background-image: url('../../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/Stored%20Procedures/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/Stored Procedures/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../../Documentation/Cayenne Guide/Queries/index.html">Queries</a></li> @@ -68,7 +68,7 @@ <div style="height: 12px; background-image: url('../../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body> Modified: cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/index.html URL: http://svn.apache.org/viewvc/cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne%20Guide/index.html?rev=1034935&r1=1034934&r2=1034935&view=diff ============================================================================== --- cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/index.html (original) +++ cayenne/main/trunk/docs/doc/src/main/resources/doc/Documentation/Cayenne Guide/index.html Sun Nov 14 05:53:19 2010 @@ -31,7 +31,7 @@ <ul> <li><a href="../../Documentation/Cayenne Guide/Introduction/index.html">Introduction</a></li> <li><a href="../../Documentation/Cayenne Guide/Installation/index.html">Installation</a></li> -<li><a href="../../Documentation/Cayenne Guide/Quick Start/index.html">Quick Start</a></li> +<li><a href="../../Documentation/Cayenne Guide/Tutorial/index.html">Tutorial</a></li> <li><a href="../../Documentation/Cayenne Guide/Design/index.html">Design</a></li> <li><a href="../../Documentation/Cayenne Guide/DataContext/index.html">DataContext</a></li> <li><a href="../../Documentation/Cayenne Guide/Queries/index.html">Queries</a></li> @@ -53,7 +53,7 @@ <ol> <li><a href="../../Documentation/Cayenne Guide/Introduction/index.html" title="Introduction">Introduction</a></li> <li><a href="../../Documentation/Cayenne Guide/Installation/index.html" title="Installation">Installation</a></li> - <li><a href="../../Documentation/Cayenne Guide/Quick Start/index.html" title="Quick Start">Quick Start</a></li> + <li><a href="../../Documentation/Cayenne Guide/Tutorial/index.html" title="Tutorial">Tutorial</a></li> <li><a href="../../Documentation/Cayenne Guide/Design/index.html" title="Design">Design</a></li> <li><a href="../../Documentation/Cayenne Guide/DataContext/index.html" title="DataContext">DataContext</a></li> <li><a href="../../Documentation/Cayenne Guide/Queries/index.html" title="Queries">Queries</a></li> @@ -74,7 +74,7 @@ <div style="height: 12px; background-image: url('../../images/border_bottom.gif'); background-repeat: repeat-x;"></div> <div class="smalltext copyright"> - Copyright ©2001-2008 Apache Software Foundation + Copyright ©2001-2010 Apache Software Foundation </div> </body>
