/** Update retryCount. Presently used for reminder alert messages */ public void updateAlertCount() { Session session = HibernateUtil.getSessionFactory().openSession(); session.beginTransaction(); String hql = "from Alert where aid=:aid and alertType=:alertType"; Query query = session.createQuery(hql); query.setString("aid", patient.getAlertId()); query.setInteger("alertType", SMS_TYPE); Alert alert = (Alert) query.list().get(0); int retryCount = alert.getretryCount() + 1; alert.setretryCount(retryCount); session.update(alert); session.getTransaction().commit(); session.close(); }