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

Example 11 with Query

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

the class TblModuleManifestJpaController method findTblModuleManifestByUuid.

public TblModuleManifest findTblModuleManifestByUuid(String uuid) {
    EntityManager em = getEntityManager();
    try {
        Query query = em.createNamedQuery("TblModuleManifest.findByUuidHex");
        query.setParameter("uuid_hex", uuid);
        TblModuleManifest pcrObj = (TblModuleManifest) query.getSingleResult();
        return pcrObj;
    } catch (NoResultException e) {
        log.error(String.format("Module information with UUID {} not found in the DB.", uuid));
        return null;
    } finally {
        em.close();
    }
}

Example 12 with Query

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

the class TblOsJpaController method findTblOsEntities.

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

Example 13 with Query

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

the class TblPackageNamespaceJpaController method getTblPackageNamespaceCount.

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

Example 14 with Query

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

the class TblPackageNamespaceJpaController method findByName.

public TblPackageNamespace findByName(String name) {
    EntityManager em = getEntityManager();
    try {
        Query query = em.createNamedQuery("TblPackageNamespace.findByName");
        query.setParameter("name", name);
        // Nov 14, 2013: Commenting out the below setting for better performance and updating the cacheusage to check cache and then DB                        
        //query.setHint(QueryHints.REFRESH, HintValues.TRUE);
        query.setHint(QueryHints.CACHE_USAGE, CacheUsage.CheckCacheThenDatabase);
        TblPackageNamespace tblPNS = (TblPackageNamespace) query.getSingleResult();
        return tblPNS;
    } finally {
        em.close();
    }
}

Example 15 with Query

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

the class TblPcrManifestJpaController method findTblPcrManifestEntities.

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