Select distinct with Spring Hibernate Sessionfactory?

Simply write the following HQL: sessionFactory. GetCurrentSession(). CreateQuery("select distinct from City").list() or even better (with result transformer).

Simply write the following HQL: sessionFactory. GetCurrentSession(). CreateQuery("select distinct from City").list() or even better (with result transformer): Query q = sessionFactory.

GetCurrentSession(). CreateQuery("from City"); q. SetResultTransformer(CriteriaSpecification.

DISTINCT_ROOT_ENTITY).

– Jaanus Sep 16 at 14:31 SELECT DISTINCT doesn't follow SQL guidelines but HQL one - meaning, distinction is done by id. Return type for the 2nd solution is your City entity. I find the 2nd one better in most cases.

– Bivas Sep 18 at 21:11.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.