Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/events/Subscription.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/events/Attic/Subscription.hbm.xml,v
diff -u -r1.1 -r1.2
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/events/Subscription.hbm.xml	25 Aug 2008 08:15:43 -0000	1.1
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/events/Subscription.hbm.xml	28 Sep 2009 05:47:23 -0000	1.2
@@ -49,6 +49,19 @@
             column="user_id"
         />
 
+        <many-to-one
+            name="event"
+            class="org.lamsfoundation.lams.events.Event"
+            cascade="none"
+            outer-join="auto"
+            update="true"
+            insert="true"
+        >
+            <column
+                name="event_uid" 
+            />
+        </many-to-one>
+
         <property
             name="deliveryMethodId"
             type="java.lang.Short"
Index: lams_common/src/java/org/lamsfoundation/lams/events/Subscription.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/events/Subscription.java,v
diff -u -r1.2 -r1.3
--- lams_common/src/java/org/lamsfoundation/lams/events/Subscription.java	17 Sep 2008 01:08:29 -0000	1.2
+++ lams_common/src/java/org/lamsfoundation/lams/events/Subscription.java	28 Sep 2009 05:47:23 -0000	1.3
@@ -24,6 +24,8 @@
 	 * ID of the subscribed user
 	 */
 	protected Long userId;
+	
+	protected Event event;
 
 	/**
 	 * ID of the delivery method used to send a message for this subscription.
@@ -125,6 +127,19 @@
 		return userId;
 	}
 
+	/**
+	 * @hibernate.many-to-one
+	 * @hibernate.column name="event_uid"
+	 * @return
+	 */
+	public Event getEvent() {
+		return event;
+	}
+
+	public void setEvent(Event event) {
+		this.event = event;
+	}
+
 	@Override
 	public int hashCode() {
 		return new HashCodeBuilder().append(getUserId()).append(getDeliveryMethod()).toHashCode();
Index: lams_common/src/java/org/lamsfoundation/lams/events/dao/hibernate/EventDAOHibernate.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/events/dao/hibernate/EventDAOHibernate.java,v
diff -u -r1.2 -r1.3
--- lams_common/src/java/org/lamsfoundation/lams/events/dao/hibernate/EventDAOHibernate.java	1 Jul 2009 02:47:11 -0000	1.2
+++ lams_common/src/java/org/lamsfoundation/lams/events/dao/hibernate/EventDAOHibernate.java	28 Sep 2009 05:47:23 -0000	1.3
@@ -13,8 +13,8 @@
 	    + " AS e WHERE e.scope=? AND e.name=? AND e.eventSessionId=? AND e.failTime IS NULL";
 
     protected static final String GET_EVENTS_TO_RESEND_QUERY = "SELECT DISTINCT e FROM " + Event.class.getName()
-	    + " AS e LEFT JOIN FETCH e.subscriptions AS s WHERE e.failTime IS NOT NULL OR "
-	    + "(s.periodicity > 0 AND (NOW()- s.lastOperationTime >= s.periodicity))";
+	    + " AS e, Subscription AS s WHERE s.event = e AND (e.failTime IS NOT NULL OR "
+	    + "(s.periodicity > 0 AND (NOW()- s.lastOperationTime >= s.periodicity)))";
 
     public Event getEvent(String scope, String name, Long sessionId) throws InvalidParameterException {
 	List<Event> events = getHibernateTemplate().find(EventDAOHibernate.GET_EVENT_QUERY,