[Hibernate] Hibernate Query Object

2003-10-24 Thread Chandrasekhar Ambadipudi
Hi, Iam trying to use pagenation by Query object and its setMaxRows, setFirstRow. I have a block of code like this String oql = FIND_BY_TEAM_OQL; Session sess = null; try { sess = basePersistence.getSessionFactory().openSession(); uery

[Hibernate] Query with multiple classes - how?

2003-10-24 Thread Maurice le Rutte
The Hibernate documentation states in chapter 9 (Hibernate Query Language) Multiple classes may appear, resulting in a cartesian product or cross join. from Formula, Parameter from Formula as form, Parameter as param A bit later something similar: select cat, count( elements(cat.kittens) )

Re: [Hibernate] Query with multiple classes - how?

2003-10-24 Thread Christian Bauer
On 24 Oct (20:49), Maurice le Rutte wrote: select cat, count( elements(cat.kittens) ) from eg.Cat cat group by cat It is not clear to me what the result of such a query would be. What type would be the contents of the objects contained by the collection returned by the query's list() or

[Hibernate] RE: Hibernate Query Object

2003-10-24 Thread Chandrasekhar Ambadipudi
Actually I could solve this problem...I havent looked enough in to API dcoumentation for the method query.setParameter :-) Bind a value to a JDBC-style query parameter. Parameters: position - the position of the parameter in the query string,