Index: lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java =================================================================== RCS file: /usr/local/cvsroot/lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java,v diff -u -r1.4.2.2 -r1.4.2.3 --- lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java 11 May 2016 07:14:45 -0000 1.4.2.2 +++ lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java 10 Jan 2017 05:15:34 -0000 1.4.2.3 @@ -20,7 +20,6 @@ * **************************************************************** */ - package org.lamsfoundation.lams.monitoring.quartz.job; import java.util.Collection; @@ -30,6 +29,7 @@ import org.lamsfoundation.lams.events.IEventNotificationService; import org.lamsfoundation.lams.monitoring.service.IMonitoringService; import org.lamsfoundation.lams.usermanagement.User; +import org.lamsfoundation.lams.util.hibernate.HibernateSessionManager; import org.lamsfoundation.lams.web.util.AttributeNames; import org.quartz.JobExecutionContext; import org.quartz.JobExecutionException; @@ -64,9 +64,10 @@ Long activityId = (Long) properties.get(AttributeNames.PARAM_ACTIVITY_ID); Integer xDaystoFinish = (Integer) properties.get("daysToDeadline"); String[] lessonIds = (String[]) properties.get("lessonIDs"); + + HibernateSessionManager.openSession(); Collection users = getMonitoringService(context).getUsersByEmailNotificationSearchType(searchType, lessonId, lessonIds, activityId, xDaystoFinish, orgId); - for (User user : users) { boolean isHtmlFormat = false; int userId = user.getUserId(); @@ -76,6 +77,7 @@ .getMessage("event.emailnotifications.email.subject", new Object[] {}), emailBody, isHtmlFormat); } + HibernateSessionManager.closeSession(); } private IEventNotificationService getEventNotificationService(JobExecutionContext context)