DetachedCriteria criteria = DetachedCriteria.forClass(ReceivingReport.class);
criteria.add(Restrictions.eq("idDealer", idDealer));
criteria.add(Restrictions.between("year", initialYear, finalYear));
criteria.add(Restrictions.eq("type", type));
criteria.addOrder(Order.asc("year"));
criteria.addOrder(Order.asc("month"));
List<ReceivingReport> lista = getHibernateTemplate().findByCriteria(criteria);
String query = "Select * From vw_FilesDataSheet Where id_Dealer = 2354512 AND nYear Between 2006 And 2008 And vcFileType = 'INF' Order BY
nYear, nMonth";
lista = getSession().createSQLQuery(query).addEntity(ReceivingReport.class).list();
lista = (List<ReceivingReport>) getSession().createSQLQuery(query).list();
Fiquei perplexo com esse comportamento do Hibernate. Será que alguma configuração está incorreta?
Obrigado! :mrgreen: