### Question:
NotificationTemplateDao extends NamedParameterJdbcDaoSupport { @Transactional(propagation = Propagation.SUPPORTS) public NotificationTemplate loadNotificationTemplate(Long id) { List<NotificationTemplate> items = getJdbcTemplate().query(loadNotificationTemplateQuery, NotificationTemplateParameters.getRowMapper(), id); return !items.isEmpty() ? items.get(0) : null; }  @Transactional(propagation = Propagation.MANDATORY) NotificationTemplate createNotificationTemplate(NotificationTemplate notificationTemplate); @Transactional(propagation = Propagation.SUPPORTS) NotificationTemplate loadNotificationTemplate(Long id); List<NotificationTemplate> loadAllNotificationTemplates(); @Transactional(propagation = Propagation.MANDATORY) NotificationTemplate updateNotificationTemplate(NotificationTemplate template); @Transactional(propagation = Propagation.MANDATORY) void deleteNotificationTemplate(long templateId); @Required void setCreateNotificationTemplateQuery(String createNotificationTemplateQuery); @Required void setLoadNotificationTemplateQuery(String loadNotificationTemplateQuery); @Required void setLoadAllNotificationTemplatesQuery(String loadAllNotificationTemplatesQuery); @Required void setUpdateNotificationTemplateQuery(String updateNotificationTemplateQuery); @Required void setDeleteNotificationTemplateQuery(String deleteNotificationTemplateQuery);  }### Answer:
@Test @Transactional(propagation = Propagation.REQUIRES_NEW) public void loadNotificationTemplate() { NotificationTemplate template = createTemplate(); NotificationTemplate notificationTemplate = notificationTemplateDao.createNotificationTemplate(template); NotificationTemplate loaded = notificationTemplateDao.loadNotificationTemplate(notificationTemplate.getId()); Assert.assertEquals(loaded.getSubject(), SUBJECT_STRING); Assert.assertEquals(loaded.getBody(), BODY_STRING); Assert.assertEquals(loaded.getName(), TEST_NAME); List<NotificationTemplate> templates = notificationTemplateDao.loadAllNotificationTemplates(); Assert.assertFalse(templates.isEmpty()); }