Examples with Query org.hibernate.query.Query used on opensource projects

Example 76 with Query

use of org.hibernate.query.Query in project hibernate-orm by hibernate.

the class AbstractRelationQueryGenerator method getQuery.

@Override
public Query getQuery(AuditReaderImplementor versionsReader, Object primaryKey, Number revision, boolean removed) {
    final Query query = versionsReader.getSession().createQuery(removed ? getQueryRemovedString() : getQueryString());
    query.setParameter(DEL_REVISION_TYPE_PARAMETER, RevisionType.DEL);
    query.setParameter(REVISION_PARAMETER, revision);
    for (QueryParameterData paramData : referencingIdData.getPrefixedMapper().mapToQueryParametersFromId(primaryKey)) {
        paramData.setParameterValue(query);
    }
    return query;
}

Example 77 with Query

use of org.hibernate.query.Query in project nikita-noark5-core by HiOA-ABI.

the class HQLStatementBuilder method buildHQLStatement.

public Query buildHQLStatement(Session session) {
    // take care of the select part
    StringBuffer hqlStatement = new StringBuffer(select);
    // add an 'and' here.
    for (String where : whereList) {
        hqlStatement.append(" and ");
        hqlStatement.append(where);
    }
    hqlStatement.append(" ");
    Query query = session.createQuery(hqlStatement.toString());
    // take care of the orderBy part
    boolean firstOrderBy = false;
    for (Map.Entry entry : orderByMap.entrySet()) {
        if (firstOrderBy) {
            hqlStatement.append(", ");
        } else {
            hqlStatement.append(" order by ");
            firstOrderBy = true;
        }
        hqlStatement.append(entry.getKey() + " " + entry.getValue());
    }
    query.setFirstResult(limitOffset);
    query.setMaxResults(limitHowMany);
    String queryString = query.getQueryString();
    out.println("HQL Query string is " + queryString);
    return query;
}

Example 78 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class StudyEventDao method findByStudyEventId.

@Transactional
public StudyEvent findByStudyEventId(int studyEventId) {
    Query q = getCurrentSession().createQuery(findByStudyEventIdQuery);
    q.setParameter("studyEventId", studyEventId);
    return (StudyEvent) q.uniqueResult();
}

Example 79 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class StudyEventDao method findMaxOrdinalByStudySubjectStudyEventDefinition.

public Integer findMaxOrdinalByStudySubjectStudyEventDefinition(int studySubjectId, int studyEventDefinitionId) {
    String query = "select max(sample_ordinal) from study_event where study_subject_id = " + studySubjectId + " and study_event_definition_id = " + studyEventDefinitionId;
    Query q = getCurrentSession().createSQLQuery(query);
    Number result = (Number) q.uniqueResult();
    if (result == null)
        return 0;
    else
        return result.intValue();
}

Example 80 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class VersioningMapDao method findByVersionIdAndItemId.

public ArrayList<VersioningMap> findByVersionIdAndItemId(int versionId, int itemId) {
    String query = "from " + getDomainClassName() + " vm  where vm.crfVersion.crfVersionId = :versionId and  vm.item.itemId = :itemId";
    Query q = getCurrentSession().createQuery(query);
    q.setParameter("versionId", versionId);
    q.setParameter("itemId", itemId);
    return (ArrayList<VersioningMap>) q.list();
}