Example usage for org.hibernate.criterion DetachedCriteria createCriteria

List of usage examples for org.hibernate.criterion DetachedCriteria createCriteria

Introduction

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

Prototype

@Deprecated
public DetachedCriteria createCriteria(String associationPath, int joinType) 

Source Link

Document

Deprecated!

Usage

From source file:org.sipfoundry.sipxconfig.common.SipxHibernateDaoSupport.java

License:Contributor Agreement License

/**
 * Update a Criteria object for filtering beans by branch membership. If brnachId is null,
 * then don't filter by branch./*from   ww w .j  a  va 2  s .c  o m*/
 */
public static void addByBranchCriteria(DetachedCriteria crit, Integer branchId) {
    if (branchId != null) {
        crit.createCriteria("branch", "b").add(Restrictions.eq("b.id", branchId));
    }
}

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;

    criteria = DetachedCriteria.forClass(GlycanSequence.class);

    DetachedCriteria bc_criteria;//from  www.j a v a  2s  .  com
    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();
}