The query is generated with a comma after distinct keyword which is not expected.
Code: final Integer result = (Integer) this.getHibernateTemplate() .executeWithNativeSession(new HibernateCallback<Object>() {
public Object doInHibernate(final Session session) {
Criteria criteria1 = session .createCriteria( TimeReminderResultDTO User .class);
criteria1.setProjection(Projections.countDistinct("id"));
final Integer totalRecs = ((Integer) criteria1 .uniqueResult());
return totalRecs; } });
Query generated: select count(distinct, this_.id) as y0_ from tbl usr this_
|