Examples with NonUniqueResultException javax.persistence.NonUniqueResultException used on opensource projects

Example 41 with NonUniqueResultException

use of javax.persistence.NonUniqueResultException in project Asqatasun by Asqatasun.

the class OptionElementDAO method findOptionElementFromValueAndOption.

/**
 * @param value
 * @param option
 * @return
 */
public OptionElementImpl findOptionElementFromValueAndOption(String value, Option option) {
    Query query = entityManager.createQuery("SELECT oe FROM " + getEntityClass().getName() + " oe" + " WHERE oe.value=:value" + " AND oe.option=:option");
    query.setParameter("value", value);
    query.setParameter("option", option);
    try {
        return (OptionElementImpl) query.getSingleResult();
    } catch (NoResultException | NonUniqueResultException nre) {
        return null;
    }
}

Example 42 with NonUniqueResultException

use of javax.persistence.NonUniqueResultException in project Asqatasun by Asqatasun.

the class ContentDAOImpl method find.

@Override
public Content find(WebResource page, String uri) {
    Query query = entityManager.createQuery("SELECT c FROM " + getEntityClass().getName() + " c" + " WHERE c.page = :page " + " AND c.uri = :uri");
    query.setParameter("page", page);
    query.setParameter("uri", uri);
    try {
        return (Content) query.getSingleResult();
    } catch (NoResultException nre) {
        return null;
    } catch (NonUniqueResultException nure) {
        List<Content> queryResult = query.getResultList();
        for (Content content : queryResult) {
            if (StringUtils.equals(content.getURI(), uri)) {
                return content;
            }
        }
        return null;
    }
}

Example 43 with NonUniqueResultException

use of javax.persistence.NonUniqueResultException in project Asqatasun by Asqatasun.

the class OptionDAOImpl method findOptionFromCode.

@Override
public Option findOptionFromCode(String optionCode) {
    Query query = entityManager.createQuery("SELECT o FROM " + getEntityClass().getName() + " o" + " WHERE o.code = :optionCode");
    query.setParameter("optionCode", optionCode);
    try {
        return (Option) query.getSingleResult();
    } catch (NoResultException nre) {
        return null;
    } catch (NonUniqueResultException nure) {
        return null;
    }
}

Example 44 with NonUniqueResultException

use of javax.persistence.NonUniqueResultException in project Asqatasun by Asqatasun.

the class OptionElementDAOImpl method findOptionElementFromUserAndFamilyCode.

@Override
public Collection<OptionElement> findOptionElementFromUserAndFamilyCode(User user, String optionFamilyCode) {
    Query query = entityManager.createQuery("SELECT distinct(u.optionElementSet) FROM " + getUserEntityClass().getName() + " u" + " LEFT JOIN u.optionElementSet oe" + " WHERE u=:user" + " AND oe.option.optionFamily.code=:optionFamilyCode");
    query.setParameter("user", user);
    query.setParameter("optionFamilyCode", optionFamilyCode);
    try {
        return (Collection<OptionElement>) query.getResultList();
    } catch (NoResultException | NonUniqueResultException nre) {
        return null;
    }
}

Example 45 with NonUniqueResultException

use of javax.persistence.NonUniqueResultException in project ORCID-Source by ORCID.

the class OrcidPropsDaoImpl method getValue.

@Override
public String getValue(String key) {
    Assert.hasText(key, "Cannot look for empty keys");
    Query query = entityManager.createQuery("SELECT value FROM OrcidPropsEntity WHERE key=:key");
    query.setParameter("key", key);
    try {
        return (String) query.getSingleResult();
    } catch (NonUniqueResultException nure) {
        throw nure;
    } catch (NoResultException nre) {
        return null;
    }
}