Index: lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java =================================================================== diff -u -r3399163940c61c9132223c758d274486e57ff9b7 -rd22212e485e30795f0fbff1a9af16814a6ecc544 --- lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java (.../EmailScheduleMessageJob.java) (revision 3399163940c61c9132223c758d274486e57ff9b7) +++ lams_monitoring/src/java/org/lamsfoundation/lams/monitoring/quartz/job/EmailScheduleMessageJob.java (.../EmailScheduleMessageJob.java) (revision d22212e485e30795f0fbff1a9af16814a6ecc544) @@ -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)