posted 9 years ago
Ya its single query like folloinwg :
session = openHibernateSession();
Criteria criteria = session.createCriteria(TableName.class);
criteria.add(Restrictions.eq("ID1", 1));
criteria.add(Restrictions.eq("ID2", 1));
criteria.add(Restrictions.eq("ID3", 349));
criteria.setProjection(Projections.max("creationtimestamp"));
long endDateInEpoch = (Long) criteria.uniqueResult();
endDate = new Date(endDateInEpoch*1000);