From: <one...@us...> - 2003-03-03 01:07:06
|
Update of /cvsroot/hibernate/Hibernate2/doc/reference/src In directory sc8-pr-cvs1:/tmp/cvs-serv9746/reference/src Modified Files: examples.xml manipulating_data.xml query_language.xml transactions.xml Log Message: documented latest QL changes Index: examples.xml =================================================================== RCS file: /cvsroot/hibernate/Hibernate2/doc/reference/src/examples.xml,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** examples.xml 23 Feb 2003 13:53:24 -0000 1.4 --- examples.xml 3 Mar 2003 01:07:03 -0000 1.5 *************** *** 254,261 **** <mediaobject> <imageobject role="fo"> ! <imagedata fileref="images/AuthorWork.gif" format="GIF" align="center"/> </imageobject> <imageobject role="html"> ! <imagedata fileref="../images/AuthorWork.gif" format="GIF" align="center"/> </imageobject> </mediaobject> --- 254,261 ---- <mediaobject> <imageobject role="fo"> ! <imagedata fileref="images/CustomerOrderProduct.gif" format="GIF" align="center"/> </imageobject> <imageobject role="html"> ! <imagedata fileref="../images/CustomerOrderProduct.gif" format="GIF" align="center"/> </imageobject> </mediaobject> Index: manipulating_data.xml =================================================================== RCS file: /cvsroot/hibernate/Hibernate2/doc/reference/src/manipulating_data.xml,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** manipulating_data.xml 23 Feb 2003 13:53:24 -0000 1.3 --- manipulating_data.xml 3 Mar 2003 01:07:03 -0000 1.4 *************** *** 96,100 **** <programlisting><![CDATA[List cats = sess.find( ! "from cat in class eg.Cat where cat.birthdate = ?", date, Hibernate.DATE --- 96,100 ---- <programlisting><![CDATA[List cats = sess.find( ! "from eg.Cat as cat where cat.birthdate = ?", date, Hibernate.DATE *************** *** 102,115 **** List mates = sess.find( ! "select mate from cat in class eg.Cat, cat in class eg.DomesticCat where " + ! "cat.mate = mate and cat.name = ?", name, Hibernate.STRING ); ! List cats = sess.find( "from cat in class eg.Cat where cat.mate.bithdate is null" ); List moreCats = sess.find( ! "from cat in class eg.Cat where " + "cat.name = 'Fritz' or cat.id = ? or cat.id = ?", new Object[] { id1, id2 }, --- 102,115 ---- List mates = sess.find( ! "select mate from eg.Cat as cat join cat.mate as mate " + ! "where cat.name = ?", name, Hibernate.STRING ); ! List cats = sess.find( "from eg.Cat as cat where cat.mate.bithdate is null" ); List moreCats = sess.find( ! "from eg.Cat as cat where " + "cat.name = 'Fritz' or cat.id = ? or cat.id = ?", new Object[] { id1, id2 }, *************** *** 118,122 **** List problems = sess.find( ! "from fish in class fish.GoldFish " + "where fish.birthday > fish.deceased or fish.birthday is null" );]]></programlisting> --- 118,122 ---- List problems = sess.find( ! "from fish.GoldFish as fish " + "where fish.birthday > fish.deceased or fish.birthday is null" );]]></programlisting> *************** *** 142,146 **** <programlisting><![CDATA[// fetch ids ! Iterator iter = sess.iterate("from q in class eg.Qux order by q.likeliness"); while ( iter.hasNext() ) { Qux qux = (Qux) iter.next(); // fetch the object --- 142,146 ---- <programlisting><![CDATA[// fetch ids ! Iterator iter = sess.iterate("from eg.Qux q order by q.likeliness"); while ( iter.hasNext() ) { Qux qux = (Qux) iter.next(); // fetch the object *************** *** 172,178 **** <programlisting><![CDATA[ Iterator iter = sess.iterate( ! "select customer, product from customer in class Customer, " + ! "product in class Product, " + ! "purchase in customer.purchases " + "where product = purchase.product" );]]></programlisting> --- 172,179 ---- <programlisting><![CDATA[ Iterator iter = sess.iterate( ! "select customer, product " + ! "from Customer customer, " + ! "Product product " + ! "join customer.purchases purchase " + "where product = purchase.product" );]]></programlisting> *************** *** 189,193 **** <programlisting><![CDATA[Iterator foosAndBars = sess.iterate( ! "select foo, bar from foo in class eg.Foo, bar in class eg.Bar" + "where bar.date = foo.date" ); --- 190,194 ---- <programlisting><![CDATA[Iterator foosAndBars = sess.iterate( ! "select foo, bar from eg.Foo foo, eg.Bar bar " + "where bar.date = foo.date" ); *************** *** 209,213 **** <programlisting><![CDATA[Iterator results = sess.iterate( ! "select cat.color, min(cat.birthdate), count(cat) from cat in class eg.Cat " + "group by cat.color" ); --- 210,214 ---- <programlisting><![CDATA[Iterator results = sess.iterate( ! "select cat.color, min(cat.birthdate), count(cat) from eg.Cat cat " + "group by cat.color" ); *************** *** 221,229 **** <programlisting><![CDATA[Iterator iter = sess.iterate( ! "select cat.type, cat.birthdate, cat.name from cat in class eg.DomesticCat" );]]></programlisting> <programlisting><![CDATA[List list = sess.find( ! "select cat, cat.mate.name from cat in class eg.DomesticCat" );]]></programlisting> --- 222,230 ---- <programlisting><![CDATA[Iterator iter = sess.iterate( ! "select cat.type, cat.birthdate, cat.name from eg.DomesticCat cat" );]]></programlisting> <programlisting><![CDATA[List list = sess.find( ! "select cat, cat.mate.name from eg.DomesticCat cat" );]]></programlisting> *************** *** 239,243 **** </para> ! <programlisting><![CDATA[Query q = sess.createQuery("from cat in class eg.DomesticCat"); q.setFirstResult(20); q.setMaxResults(10); --- 240,244 ---- </para> ! <programlisting><![CDATA[Query q = sess.createQuery("from eg.DomesticCat cat"); q.setFirstResult(20); q.setMaxResults(10); *************** *** 251,255 **** <programlisting><![CDATA[<query name="eg.DomesticCat.by.name.and.minimum.weight"><![CDATA[ ! from cat in class eg.DomesticCat where cat.name = ? and cat.weight > ? --- 252,256 ---- <programlisting><![CDATA[<query name="eg.DomesticCat.by.name.and.minimum.weight"><![CDATA[ ! from eg.DomesticCat as cat where cat.name = ? and cat.weight > ? *************** *** 290,298 **** </itemizedlist> ! <programlisting><![CDATA[Query q = sess.createQuery("from cat in class eg.DomesticCat where cat.name = :name"); q.setString("name", "Fritz"); Iterator cats = q.iterate();]]></programlisting> ! <programlisting><![CDATA[Query q = sess.createQuery("from cat in class eg.DomesticCat where cat.name = ?"); q.setString(0, "PK"); Iterator cats = q.iterate();]]></programlisting> --- 291,299 ---- </itemizedlist> ! <programlisting><![CDATA[Query q = sess.createQuery("from eg.DomesticCat cat where cat.name = :name"); q.setString("name", "Fritz"); Iterator cats = q.iterate();]]></programlisting> ! <programlisting><![CDATA[Query q = sess.createQuery("from eg.DomesticCat cat where cat.name = ?"); q.setString(0, "PK"); Iterator cats = q.iterate();]]></programlisting> *************** *** 308,312 **** </para> ! <programlisting><![CDATA[Query q = sess.createQuery("select cat.name, cat from cat in class eg.DomesticCat " + "order by cat.name"); ScrollableResults cats = q.scroll(); --- 309,313 ---- </para> ! <programlisting><![CDATA[Query q = sess.createQuery("select cat.name, cat from eg.DomesticCat cat " + "order by cat.name"); ScrollableResults cats = q.scroll(); Index: query_language.xml =================================================================== RCS file: /cvsroot/hibernate/Hibernate2/doc/reference/src/query_language.xml,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** query_language.xml 2 Mar 2003 13:03:15 -0000 1.5 --- query_language.xml 3 Mar 2003 01:07:03 -0000 1.6 *************** *** 165,169 **** <programlisting><![CDATA[select avg(cat.weight), sum(cat.weight), max(cat.weight), count(cat) ! from eg.Cat cat></programlisting> <para> --- 165,169 ---- <programlisting><![CDATA[select avg(cat.weight), sum(cat.weight), max(cat.weight), count(cat) ! from eg.Cat cat]]></programlisting> <para> *************** *** 332,336 **** <programlisting><![CDATA[store.owner.address.city //okay ! store.owner.address //error!]]></programlisting> </sect1> --- 332,336 ---- <programlisting><![CDATA[store.owner.address.city //okay ! store.owner.address //error!]]></programlisting> </sect1> *************** *** 412,416 **** <programlisting><![CDATA[from eg.DomesticCat cat where cat.name between 'A' and 'B' ! from eg.DomesticCat cat where cat.name in ( 'Foo', 'Bar', Baz" )]]></programlisting> <para> --- 412,416 ---- <programlisting><![CDATA[from eg.DomesticCat cat where cat.name between 'A' and 'B' ! from eg.DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]></programlisting> <para> *************** *** 420,424 **** <programlisting><![CDATA[from eg.DomesticCat cat where cat.name not between 'A' and 'B' ! from eg.DomesticCat cat where cat.name not in ( 'Foo', 'Bar', Baz" )]]></programlisting> <para> --- 420,424 ---- <programlisting><![CDATA[from eg.DomesticCat cat where cat.name not between 'A' and 'B' ! from eg.DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]></programlisting> <para> *************** *** 610,614 **** <para> For databases that support subselects, Hibernate supports subqueries within queries. A subquery must ! be surrounded by parentheses (often by an SQL aggregate function call). Even /correlated/ subqueries (subqueries that refer to an alias in the outer query) are allowed. </para> --- 610,614 ---- <para> For databases that support subselects, Hibernate supports subqueries within queries. A subquery must ! be surrounded by parentheses (often by an SQL aggregate function call). Even correlated subqueries (subqueries that refer to an alias in the outer query) are allowed. </para> Index: transactions.xml =================================================================== RCS file: /cvsroot/hibernate/Hibernate2/doc/reference/src/transactions.xml,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** transactions.xml 23 Feb 2003 13:53:24 -0000 1.3 --- transactions.xml 3 Mar 2003 01:07:03 -0000 1.4 *************** *** 231,236 **** fooList = s.find( ! "select foo from foo in class eg.Foo where foo.Date = current date" ! // uses db2 date function ); bar = (Bar) s.create(Bar.class); --- 231,236 ---- fooList = s.find( ! "select foo from eg.Foo foo where foo.Date = current date" ! // uses db2 date function ); bar = (Bar) s.create(Bar.class); |