private List getLogEntries(String nhsno, Calendar startdate, Calendar enddate) throws HibernateException { List logEntries = new ArrayList(); if (nhsno != null && !nhsno.equals("")) { Session session = HibernateUtil.currentSession(); Transaction tx = session.beginTransaction(); Criteria criteria = session.createCriteria(LogEntry.class); criteria.add(Expression.between("date", startdate, enddate)); criteria.add(Expression.like("nhsno", "%" + nhsno + "%")); criteria.addOrder(Order.asc("id")); logEntries = criteria.list(); tx.commit(); HibernateUtil.closeSession(); } return logEntries; }