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

Example 1 with Query

use of javax.persistence.Query in project hibernate-orm by hibernate.

the class DetachedMultipleCollectionChangeTest method getAuditJoinTableRows.

private List<AuditJoinTableInfo> getAuditJoinTableRows(String middleEntityName, String joinColumnIdName, String joinColumnIdProp, String inverseJoinColumnIdName, String inverseJoinColumnIdProp, String revProp, String revIdProp, String revTypeProp) throws Exception {
    StringBuilder qryBuilder = new StringBuilder("select ");
    qryBuilder.append("aud ");
    qryBuilder.append(", ").append(joinColumnIdProp).append(" as joinColumnId");
    qryBuilder.append(", ").append(inverseJoinColumnIdProp).append(" as inverseJoinColumnId");
    qryBuilder.append(", ").append(revProp).append(" as rev");
    qryBuilder.append(", ").append(revIdProp).append(" as revId");
    qryBuilder.append(", ").append(revTypeProp).append(" as revType");
    qryBuilder.append(" from ").append(middleEntityName).append(" aud ");
    qryBuilder.append(" order by joinColumnId asc, inverseJoinColumnId asc, revId asc");
    String query = qryBuilder.toString();
    EntityManager em = createIsolatedEntityManager();
    Query qry = em.createQuery(query);
    @SuppressWarnings("unchecked") List<Object[]> auditJoinTableRows = qry.getResultList();
    List<AuditJoinTableInfo> result = new ArrayList<AuditJoinTableInfo>(auditJoinTableRows.size());
    for (Object[] auditJoinTableRow : auditJoinTableRows) {
        Long joinColumnId = (Long) auditJoinTableRow[1];
        Long inverseJoinColumnId = (Long) auditJoinTableRow[2];
        SequenceIdRevisionEntity rev = (SequenceIdRevisionEntity) auditJoinTableRow[3];
        RevisionType revType = (RevisionType) auditJoinTableRow[5];
        AuditJoinTableInfo info = new AuditJoinTableInfo(middleEntityName, rev, revType, joinColumnIdName, joinColumnId, inverseJoinColumnIdName, inverseJoinColumnId);
        result.add(info);
    }
    return result;
}

Example 2 with Query

use of javax.persistence.Query in project hibernate-orm by hibernate.

the class AuditColumnNameTest method testColumnName.

@Test
public void testColumnName() {
    EntityManager em = getEntityManager();
    em.getTransaction().begin();
    Query query = em.createNativeQuery("select nte_data, data_MOD_different from naming_test_entity_2_versions where nte_id = :nteId");
    query.setParameter("nteId", this.id);
    List<Object[]> resultList = query.getResultList();
    Assert.assertNotNull(resultList);
    Assert.assertTrue(resultList.size() > 0);
    Object[] result = resultList.get(0);
    Assert.assertEquals(result.length, 2);
    em.getTransaction().commit();
}

Example 3 with Query

use of javax.persistence.Query in project hibernate-orm by hibernate.

the class ValidityAuditStrategyRevEndTsTest method getRevisions.

private List<Map<String, Object>> getRevisions(Class<?> originalEntityClazz, Integer originalEntityId) {
    // Build the query:
    // select auditEntity from
    // org.hibernate.envers.test.entities.manytomany.sametable.ParentEntity_AUD
    // auditEntity where auditEntity.originalId.id = :originalEntityId
    StringBuilder builder = new StringBuilder("select auditEntity from ");
    builder.append(originalEntityClazz.getName()).append("_AUD auditEntity");
    builder.append(" where auditEntity.originalId.id = :originalEntityId");
    Query qry = getEntityManager().createQuery(builder.toString());
    qry.setParameter("originalEntityId", originalEntityId);
    @SuppressWarnings("unchecked") List<Map<String, Object>> resultList = qry.getResultList();
    return resultList;
}

Example 4 with Query

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

the class TblMleJpaController method getTblMleCount.

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

Example 5 with Query

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

the class TblMleJpaController method findTblMleByUUID.

public TblMle findTblMleByUUID(String uuid_hex) {
    EntityManager em = getEntityManager();
    try {
        Query query = em.createNamedQuery("TblMle.findByUUID_Hex");
        query.setParameter("uuid_hex", uuid_hex);
        TblMle tblOem = (TblMle) query.getSingleResult();
        return tblOem;
    } catch (NoResultException e) {
        log.error("NoResultException : MLE with UUID {} not found", uuid_hex);
        return null;
    } finally {
        em.close();
    }
}