Example usage for org.hibernate.criterion DetachedCriteria getExecutableCriteria

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria getExecutableCriteria.

Prototype

public Criteria getExecutableCriteria(Session session)

Source Link

Document

Get an executable instance of Criteria to actually run the query.

Usage

From source file:ru.apertum.qsystem.server.Spring.java

License:Open Source License

public List findByCriteria(DetachedCriteria dCriteria) {
    List list;//from  ww w  .j  a v a  2 s. co  m
    final Session ses = getTxManager().getSessionFactory().openSession();
    try {
        list = dCriteria.getExecutableCriteria(ses).list();
    } finally {
        ses.close();
    }
    return list;
}

From source file:test.eurocarbdb.dataaccess.core.SubQueryTest.java

License:Open Source License

public void canDetachedSubQuery() {
    super.setup();
    String taxonomyName = "homo sapiens";

    //Criteria subcriteria = em.createQuery( GlycanSequence.class ).setMaxResults( 20 );
    DetachedCriteria subcriteria = DetachedCriteria.forClass(GlycanSequence.class);

    DetachedCriteria criteria;//  ww  w  .  j a  v a 2s. co m

    criteria = DetachedCriteria.forClass(GlycanSequence.class);

    DetachedCriteria bc_criteria;
    DetachedCriteria tax_criteria;

    bc_criteria = criteria.createCriteria("glycanContexts").createCriteria("biologicalContext", "bc");

    // add taxonomy criteria        
    if (taxonomyName != null) {
        tax_criteria = bc_criteria.createCriteria("taxonomy", "taxa")
                .createCriteria("taxonomySupertypes", "supertax")
                .add(Restrictions.ilike("taxon", taxonomyName, MatchMode.EXACT));
    }

    criteria.setProjection(Projections.distinct(Projections.property("glycanSequenceId")));

    subcriteria.add(Subqueries.propertyIn("glycanSequenceId", criteria));

    //System.out.println(subcriteria.list().size());
    subcriteria.getExecutableCriteria(((HibernateEntityManager) em).getHibernateSession()).list();

    super.teardown();
}

From source file:tw.edu.chit.dao.hibernate.MemberDAOImpl.java

@SuppressWarnings("unchecked")
public List submitQueryByCriteria(DetachedCriteria criteria) {
    return criteria.getExecutableCriteria(getSession()).list();
}

From source file:uk.org.openeyes.DatabaseFunctions.java

/**
 *  This method can be used with IOLM700 when we extract the string representation of the Eye Status
 * @param EyeStatus//from   w ww  . j av  a 2 s  .c  o  m
 */
public Integer getEyeStatusFromSting(String eyeStatus) {
    DicomEyeStatus status;
    Criteria crit = session.createCriteria(DicomEyeStatus.class);
    crit.add(Restrictions.eq("name", eyeStatus));
    List statusList = crit.list();

    System.out.println("Eye status: " + eyeStatus);

    if (statusList.isEmpty()) {
        DetachedCriteria criteria = DetachedCriteria.forClass(DicomEyeStatus.class)
                .setProjection(Projections.max("id"));
        Integer maxId = (Integer) criteria.getExecutableCriteria(session).list().get(0);
        Integer newId = 0;
        status = new DicomEyeStatus();
        status.setName(eyeStatus);

        if (maxId < 1000) {
            newId = 1000;
        } else {
            newId = maxId + 1;
        }
        status.setId(newId);
        session.save(status);
        session.flush();
    } else {
        status = (DicomEyeStatus) statusList.get(0);
    }

    return status.getId();
}

From source file:wa.tutorial.jsf.semerujsf.model.dao.HibernateDAO.java

@Override
public List<T> getEntitiesByDetachedCriteria(DetachedCriteria criteria) {
    List<T> entities = (List<T>) criteria.getExecutableCriteria(session).list();
    return entities;
}

From source file:zcu.xutil.orm.HEntityManager.java

License:Apache License

public List findByCriteria(DetachedCriteria criteria, int firstResult, int maxResults) {
    Disposable sessionCloser = opensession();
    try {/*  w  w w .  j a va 2 s .  c o  m*/
        Criteria executableCriteria = criteria.getExecutableCriteria(getCurrentSession());
        if (firstResult >= 0)
            executableCriteria.setFirstResult(firstResult);
        if (maxResults > 0)
            executableCriteria.setMaxResults(maxResults);
        return executableCriteria.list();
    } finally {
        sessionCloser.destroy();
    }
}