db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From b..@apache.org
Subject cvs commit: db-ojb/src/doc/forrest/src/documentation/content/xdocs/docu/guides query.xml
Date Wed, 08 Sep 2004 18:37:57 GMT
brj         2004/09/08 11:37:57

  Modified:    src/doc/forrest/src/documentation/content/xdocs/docu/guides
                        Tag: OJB_1_0_RELEASE query.xml
  Log:
  subqueries are not extent aware
  
  Revision  Changes    Path
  No                   revision
  No                   revision
  1.1.2.1   +16 -12    db-ojb/src/doc/forrest/src/documentation/content/xdocs/docu/guides/query.xml
  
  Index: query.xml
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/doc/forrest/src/documentation/content/xdocs/docu/guides/query.xml,v
  retrieving revision 1.1
  retrieving revision 1.1.2.1
  diff -u -r1.1 -r1.1.2.1
  --- query.xml	20 Jun 2004 09:12:33 -0000	1.1
  +++ query.xml	8 Sep 2004 18:37:57 -0000	1.1.2.1
  @@ -293,6 +293,10 @@
   Query q = QueryFactory.newQuery(ProductGroup.class, crit);
   
   Collection results = broker.getCollectionByQuery(q);]]></source>
  +			<note>
  +			Subqueries are not extent aware. Thus it's not possible to use an abstract class or
an interface as search 
  +			class of a subquery.
  +			</note>
               </section>
   
               <section>
  @@ -656,7 +660,7 @@
                   The ReportQuery returns an Iterator over a Collection of
                   Object[4] ([String, Integer, String, Double]).
                   </p>
  -                
  +
                   <section>
   	                <title>Limitations of Report Queries</title>
   					<p>
  @@ -701,18 +705,18 @@
   					This ReportQuery executes the following three selects (one for each concrete extent)
and produces better results.
   					</p>
                   <source><![CDATA[
  -SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis) 
  -FROM artikel A0 
  +SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis)
  +FROM artikel A0
   INNER JOIN Kategorien A1 ON A0.Kategorie_Nr=A1.Kategorie_Nr
   GROUP BY A1.KategorieName
   
  -SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis) 
  -FROM cds A0 
  +SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis)
  +FROM cds A0
   INNER JOIN Kategorien A1 ON A0.Kategorie_Nr=A1.Kategorie_Nr
   GROUP BY A1.KategorieName
  - 
  -SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis) 
  -FROM books A0 
  +
  +SELECT  A1.KategorieName,sum(A0.Lagerbestand),sum(A0.Einzelpreis)
  +FROM books A0
   INNER JOIN Kategorien A1 ON A0.Kategorie_Nr=A1.Kategorie_Nr
   GROUP BY A1.KategorieName
   ]]></source>
  @@ -721,8 +725,8 @@
   					the results of the ProductGroup has to be added. In our sample the ProductGroup "Books"
will be listed three times.
   					</p>
   					<p>
  -					After listing so many drawbacks and problems, here's the SQL the produces the desired
result. 
  -					This is a manually created SQL, not generated by OJB. Unfortunately it's not fully
supported by some DBMS because of 
  +					After listing so many drawbacks and problems, here's the SQL the produces the desired
result.
  +					This is a manually created SQL, not generated by OJB. Unfortunately it's not fully
supported by some DBMS because of
   					"union" and sub-selects.
   					</p>
                   <source><![CDATA[
  @@ -749,7 +753,7 @@
   ]]></source>
   
                   </section>
  -                
  +
               </section>
           </section>
   
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message