List of usage examples for org.hibernate.criterion DetachedCriteria createCriteria
@Deprecated public DetachedCriteria createCriteria(String associationPath, int joinType)
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(); }