Hello,

I want to query my results via StatelessSession and the following code does not ensure distinct root entity...
Each entity are as much available as rows are available for it. (JOIN FETCH used in query)

org.hibernate.Query query= session.statelessSession.createQuery( queryStr ).setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY ) ;
businessObjects = query.list().iterator();

Question : How can I set an join fetch query to distinct root entity ?

.. The is an "order by Object" in the sql which is execuited on the dbms..

If somebody knows it before me. Be faster here ;)

Greats & Regards !

Hm.. It must be an error in my DB2Dialect or some else. I saw a fix for scrollable.next() in this dialect and i will report of course my sollution .
On Mysql everything is working..