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_
|
