Example usage for org.springframework.dao.support DataAccessUtils requiredUniqueResult

Introduction

In this page you can find the example usage for org.springframework.dao.support DataAccessUtils requiredUniqueResult.

Prototype

public static <T> T requiredUniqueResult(@Nullable Collection<T> results)
        throws IncorrectResultSizeDataAccessException 

Source Link

Document

Return a unique result object from the given Collection.

Usage

From source file:org.yamj.core.database.service.MediaStorageService.java

@Transactional(readOnly = true)
public MediaFile getRequiredMediaFile(Long id) {
    final StringBuilder sb = new StringBuilder();
    sb.append("from MediaFile mf ");
    sb.append("left outer join fetch mf.audioCodecs ");
    sb.append("left outer join fetch mf.subtitles ");
    sb.append("left outer join fetch mf.stageFiles ");
    sb.append("where mf.id = :id");

    @SuppressWarnings("unchecked")
    List<MediaFile> objects = this.mediaDao.findById(sb, id);
    return DataAccessUtils.requiredUniqueResult(objects);
}

---

From source file:net.sf.sail.webapp.dao.user.impl.HibernateUserDao.java

/**
 * @see net.sf.sail.webapp.dao.user.UserDao#retrieveByUsername(java.lang.String)
 *///from w  w  w.j  a va  2 s  . c om
public User retrieveByUsername(String username) {
    return (User) DataAccessUtils.requiredUniqueResult(this.getHibernateTemplate().findByNamedParam(
            "from UserImpl as user where upper(user.userDetails.username) = :username", "username",
            username.toUpperCase()));
}

---

From source file:org.yamj.core.database.service.MetadataStorageService.java

@Transactional(readOnly = true)
public VideoData getRequiredVideoData(Long id) {
    final StringBuilder sb = new StringBuilder();
    sb.append("from VideoData vd ");
    sb.append("left outer join fetch vd.genres ");
    sb.append("left outer join fetch vd.credits c ");
    sb.append("where vd.id = :id");

    @SuppressWarnings("unchecked")
    List<VideoData> objects = this.commonDao.findById(sb, id);
    return DataAccessUtils.requiredUniqueResult(objects);
}

---

From source file:org.yamj.core.database.service.MetadataStorageService.java

@Transactional(readOnly = true)
public Series getRequiredSeries(Long id) {
    final StringBuilder sb = new StringBuilder();
    sb.append("from Series ser ");
    sb.append("join fetch ser.seasons sea ");
    sb.append("join fetch sea.videoDatas vd ");
    sb.append("left outer join fetch vd.credits c ");
    sb.append("where ser.id = :id");

    @SuppressWarnings("unchecked")
    List<Series> objects = this.commonDao.findById(sb, id);
    return DataAccessUtils.requiredUniqueResult(objects);
}

---

From source file:org.yamj.core.database.service.ArtworkStorageService.java

@Transactional(readOnly = true)
public Artwork getRequiredArtwork(Long id) {
    final StringBuilder sb = new StringBuilder();
    sb.append("FROM Artwork art ");
    sb.append("LEFT OUTER JOIN FETCH art.videoData ");
    sb.append("LEFT OUTER JOIN FETCH art.season ");
    sb.append("LEFT OUTER JOIN FETCH art.series ");
    sb.append("LEFT OUTER JOIN FETCH art.artworkLocated ");
    sb.append("LEFT OUTER JOIN FETCH art.person ");
    sb.append("WHERE art.id = :id");

    @SuppressWarnings("unchecked")
    List<Artwork> objects = this.artworkDao.findById(sb, id);
    Artwork artwork = DataAccessUtils.requiredUniqueResult(objects);

    if (artwork.getSeason() != null) {
        // also initialize series
        if (!Hibernate.isInitialized(artwork.getSeason().getSeries())) {
            Hibernate.initialize(artwork.getSeason().getSeries());
        }/*from  w  w  w.j a  v a 2  s  .co  m*/
    } else if (artwork.getVideoData() != null && artwork.getVideoData().getSeason() != null) {
        // also initialize season and series
        if (!Hibernate.isInitialized(artwork.getVideoData().getSeason())) {
            Hibernate.initialize(artwork.getVideoData().getSeason());
        }
        if (!Hibernate.isInitialized(artwork.getVideoData().getSeason().getSeries())) {
            Hibernate.initialize(artwork.getVideoData().getSeason().getSeries());
        }
    }
    return artwork;
}

---

From source file:org.yamj.core.database.service.ArtworkStorageService.java

@Transactional(readOnly = true)
public ArtworkLocated getRequiredArtworkLocated(Long id) {
    final StringBuilder sb = new StringBuilder();
    sb.append("FROM ArtworkLocated loc ");
    sb.append("JOIN FETCH loc.artwork art ");
    sb.append("LEFT OUTER JOIN FETCH art.videoData ");
    sb.append("LEFT OUTER JOIN FETCH art.season ");
    sb.append("LEFT OUTER JOIN FETCH art.series ");
    sb.append("LEFT OUTER JOIN FETCH art.person ");
    sb.append("LEFT OUTER JOIN FETCH loc.stageFile ");
    sb.append("WHERE loc.id = :id");

    @SuppressWarnings("unchecked")
    List<ArtworkLocated> objects = this.artworkDao.findById(sb, id);
    return DataAccessUtils.requiredUniqueResult(objects);
}

---

From source file:org.sipfoundry.sipxconfig.cdr.CdrManagerImpl.java

public int getCdrCount(Date from, Date to, CdrSearch search, User user) {
    CdrsStatementCreator psc = new SelectCount(from, to, search, user, m_tz);
    RowMapper rowMapper = new SingleColumnRowMapper(Integer.class);
    List results = getJdbcTemplate().query(psc, rowMapper);
    return (Integer) DataAccessUtils.requiredUniqueResult(results);
}

---

From source file:org.wise.portal.dao.user.impl.HibernateUserDao.java

/**
 * Given a reset password key retrieve a corresponding user.
 * @param resetPasswordKey an alphanumeric key
 * @return a User object or null if there is no user with the given reset password key
 *//* w ww .j a  v  a 2 s  . c  o m*/
@Override
public User retrieveByResetPasswordKey(String resetPasswordKey) {
    User user = null;
    try {
        user = (User) DataAccessUtils.requiredUniqueResult(this.getHibernateTemplate().findByNamedParam(
                "from UserImpl as user where user.userDetails.resetPasswordKey = :resetPasswordKey",
                "resetPasswordKey", resetPasswordKey));
    } catch (EmptyResultDataAccessException e) {
        e.printStackTrace();
    }

    return user;
}

---