NotificationDAOImpl.java

package org.itracker.persistence.dao;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.itracker.model.Notification;

import java.util.List;

/**
 *
 */
public class NotificationDAOImpl
        extends BaseHibernateDAOImpl<Notification>
        implements NotificationDAO {

    public NotificationDAOImpl() {
    }

    public Notification findById(Integer id) {
        Notification notification;

        try {
            notification = (Notification) getSession().get(Notification.class, id);
        } catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
        return notification;
    }

    @SuppressWarnings("unchecked")
    public List<Notification> findByIssueId(Integer issueId) {
        List<Notification> notifications;

        try {
            Query query = getSession().getNamedQuery(
                    "NotificationsByIssueQuery");
            query.setInteger("issueId", issueId);
            notifications = query.list();
        } catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
        return notifications;
    }

}