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

Example 21 with Query

use of javax.persistence.Query in project OpenAttestation by OpenAttestation.

the class TblOemJpaController method findTblOemByName.

public TblOem findTblOemByName(String name) {
    EntityManager em = getEntityManager();
    try {
        Query query = em.createNamedQuery("TblOem.findByName");
        query.setParameter("name", name);
        TblOem tblOem = (TblOem) query.getSingleResult();
        return tblOem;
    } catch (NoResultException e) {
        log.info("NoResultException : OEM [{}] not found", name);
        return null;
    } finally {
        em.close();
    }
}

Example 22 with Query

use of javax.persistence.Query in project OpenAttestation by OpenAttestation.

the class TblHostsJpaController method findTblHostsEntities.

private List<TblHosts> findTblHostsEntities(boolean all, int maxResults, int firstResult) {
    EntityManager em = getEntityManager();
    try {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(TblHosts.class));
        Query q = em.createQuery(cq);
        if (!all) {
            q.setMaxResults(maxResults);
            q.setFirstResult(firstResult);
        }
        List<TblHosts> results = q.getResultList();
        return results;
    } finally {
        em.close();
    }
}

Example 23 with Query

use of javax.persistence.Query in project OpenAttestation by OpenAttestation.

the class TblHostsJpaController method getTblHostsCount.

public int getTblHostsCount() {
    EntityManager em = getEntityManager();
    try {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<TblHosts> rt = cq.from(TblHosts.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    } finally {
        em.close();
    }
}

Example 24 with Query

use of javax.persistence.Query in project OpenAttestation by OpenAttestation.

the class TblLocationPcrJpaController method getTblLocationPcrCount.

public int getTblLocationPcrCount() {
    EntityManager em = getEntityManager();
    try {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<TblLocationPcr> rt = cq.from(TblLocationPcr.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    } finally {
        em.close();
    }
}

Example 25 with Query

use of javax.persistence.Query in project OpenAttestation by OpenAttestation.

the class TblLocationPcrJpaController method findTblLocationPcrByPcrValue.

public String findTblLocationPcrByPcrValue(String pcrValue) {
    EntityManager em = getEntityManager();
    try {
        Query query = em.createNamedQuery("TblLocationPcr.findByPcrValue");
        query.setParameter("pcrValue", pcrValue);
        query.setHint(QueryHints.REFRESH, HintValues.TRUE);
        query.setHint(QueryHints.CACHE_USAGE, CacheUsage.DoNotCheckCache);
        try {
            TblLocationPcr locationPcr = (TblLocationPcr) query.getSingleResult();
            String location = locationPcr.getLocation();
            log.info("PCR Value  " + pcrValue + " location " + location);
            return location;
        } catch (NoResultException e) {
            log.info("NoResultException: Location does not exist for pcr value {} ", pcrValue);
            return null;
        }
    } finally {
        em.close();
    }
}