Hy,

just a question :

Why this Query is not correctly rendered by Hibernate ? :

String req = "select store.id, " +
" (select count(quantity) FROM TItems i_2 " +
" WHERE i_2.store.id = store.id" +
" AND i_2.recall.id = :id "
+ " AND i_2.quantity = 0), " +
" (select count(quantity) FROM TItems i_3 " +
" WHERE i_3.store.id = store.id" +
" AND i_3.recall.id = :id "
+ " AND i_3.quantity > 0), 1 "
+ "FROM TStore store "
+ "WHERE EXISTS ( select items.store.id "
+ " FROM TItems items "
+ " WHERE items.store.id = store.id"
+ " AND items.recall.id = :id )" ;

Query q;
List list;

// getting StoreGroupAndCount list.
q = HibernateUtils.getSession().createQuery(req);
q.setLong("id", recall.getId());

list = q.list();





I got :
select tstore0_.StoreID as col_0_0_ from v_Store tstore0_ where exists (select titems1_.StoreID from Recall_Article_Store titems1_ where titems1_.StoreID=tstore0_.StoreID and titems1_.RecallID=?)


!!!!

HB 3.1 has some support for select clause subselects.

damn, so, HB 3.0.5 doesn't support that ? What a mazing :§

If I must use a beta version, Hibernate is not the good solution !

Don't use Hibernate then.


(By the way, I know of no other ORM solution that supports select-clause subselects.)

I'll use Hibernate, it's help me so many times, so beta version won't stop me ;)

thx gavin for u help :)