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

Example 16 with Query

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

the class TblPcrManifestJpaController method getTblPcrManifestCount.

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

Example 17 with Query

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

the class TblModuleManifestJpaController method findByMleNameEventName.

/**
     * Modified By: Sudhir on June 21st to remove the throw of ASException. Instead the NoResultException is
     * being thrown, which is caught by the caller.
     * 
     * @param mleId
     * @param componentName
     * @param eventName
     * @return 
     */
public TblModuleManifest findByMleNameEventName(Integer mleId, String componentName, String eventName) {
    EntityManager em = getEntityManager();
    try {
        log.debug(String.format("Module Manifest for MLE: %d Component: %s Event: %s", mleId, componentName, eventName));
        Query query = em.createNamedQuery("TblModuleManifest.findByMleNameEventName");
        query.setParameter("name", componentName);
        query.setParameter("eventName", eventName);
        query.setParameter("mleId", mleId);
        query.setHint(QueryHints.REFRESH, HintValues.TRUE);
        query.setHint(QueryHints.CACHE_USAGE, CacheUsage.DoNotCheckCache);
        TblModuleManifest tblModuleManifest = (TblModuleManifest) query.getSingleResult();
        return tblModuleManifest;
    } catch (NoResultException e) {
        log.error(String.format("Module Manifest for MLE %d Component %s Event %s  Not found in Database ", mleId, componentName, eventName), e);
        return null;
    } finally {
        em.close();
    }
}

Example 18 with Query

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

the class TblModuleManifestJpaController method findTblModuleManifestByMleUuid.

public List<TblModuleManifest> findTblModuleManifestByMleUuid(String mleUuid) {
    EntityManager em = getEntityManager();
    try {
        Query query = em.createNamedQuery("TblModuleManifest.findByMleUuidHex");
        query.setParameter("mle_uuid_hex", mleUuid);
        List<TblModuleManifest> moduleList = query.getResultList();
        return moduleList;
    } catch (NoResultException e) {
        log.error(String.format("MLE information with UUID {} not found in the DB.", mleUuid));
        return null;
    } finally {
        em.close();
    }
}

Example 19 with Query

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

the class TblModuleManifestLogJpaController method getTblModuleManifestLogCount.

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

Example 20 with Query

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

the class TblOemJpaController method findTblOemEntities.

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