### Question:
NotificationDao extends NamedParameterJdbcDaoSupport { public SystemNotification loadNotification(Long id) { List<SystemNotification> items = getJdbcTemplate().query( loadNotificationQuery, NotificationParameters.getRowMapper(), id ); return !items.isEmpty() ? items.get(0) : null; }  @Transactional(propagation = Propagation.MANDATORY) Long createNotificationId(); @Transactional(propagation = Propagation.MANDATORY) SystemNotification createNotification(SystemNotification notification); @Transactional(propagation = Propagation.MANDATORY) SystemNotification updateNotification(SystemNotification notification); @Transactional(propagation = Propagation.MANDATORY) void deleteNotification(Long id); List<SystemNotification> loadAllNotifications(); List<SystemNotification> filterNotifications(SystemNotificationFilterVO systemNotificationFilterVO); SystemNotification loadNotification(Long id); @Required void setNotificationSequence(String notificationSequence); @Required void setCreateNotificationQuery(String query); @Required void setUpdateNotificationQuery(String query); @Required void setDeleteNotificationQuery(String query); @Required void setListNotificationsQuery(String query); @Required void setFilterNotificationsQuery(String query); @Required void setLoadNotificationQuery(String query);  }### Answer:
@Test @Transactional(propagation = Propagation.REQUIRES_NEW) public void testLoadNotification() { notificationDao.createNotification(systemNotification); SystemNotification actualNotification = notificationDao .loadNotification(systemNotification.getNotificationId()); assertEquals(systemNotification.getNotificationId(), actualNotification.getNotificationId()); assertEquals(systemNotification.getCreatedDate(), actualNotification.getCreatedDate()); assertEquals(systemNotification.getBody(), actualNotification.getBody()); assertEquals(systemNotification.getState(), actualNotification.getState()); assertEquals(systemNotification.getSeverity(), actualNotification.getSeverity()); assertEquals(systemNotification.getTitle(), actualNotification.getTitle()); systemNotification.setBody("New Body"); notificationDao.updateNotification(systemNotification); SystemNotification updatedNotification = notificationDao .loadNotification(systemNotification.getNotificationId()); assertEquals(systemNotification.getBody(), updatedNotification.getBody()); notificationDao.createNotification(additionalNotification); List<SystemNotification> actualNotifications = notificationDao.loadAllNotifications(); assertFalse(actualNotifications.isEmpty()); Assert.assertEquals(2, actualNotifications.size()); notificationDao.deleteNotification(systemNotification.getNotificationId()); notificationDao.deleteNotification(additionalNotification.getNotificationId()); assertTrue(notificationDao.loadAllNotifications().isEmpty()); }