Skip to content

Instantly share code, notes, and snippets.

@thedanielhanke

thedanielhanke/gist:6e0a067e1c2dc1e6cb23

Forked from jeffsheets/gist:5292986
Created February 23, 2016 14:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save thedanielhanke/6e0a067e1c2dc1e6cb23 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save thedanielhanke/6e0a067e1c2dc1e6cb23 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @jeffsheets jeffsheets revised this gist Apr 2, 2013. 1 changed file with 16 additions and 0 deletions.
    16 changes: 16 additions & 0 deletions gistfile1.java
    View file
    Original file line number Diff line number Diff line change
    @@ -25,3 +25,19 @@

    //Limit results to first 2000 Persons that have an address matching the given state abbreviation
    List<Person> results = getHibernateTemplate().findByCriteria(criteria, 0, 2000);



    /**
    * A second option can be used
    * if addresses is set as lazy="false" and fetch="subselect" in hbm.xml
    * (also use this if the previous JOIN method causes duplicate rows)
    */
    DetachedCriteria criteria = DetachedCriteria.forClass(Person.class, "p");

    //To pull back ALL addresses use FULL_JOIN. To only pull back matching addresses use LEFT_JOIN
    int joinType = showAllAddresses ? CriteriaSpecification.FULL_JOIN : CriteriaSpecification.LEFT_JOIN;
    criteria.createAlias("addresses", "addr", joinType);

    criteria.createAlias("addr.state", "st");
    criteria.add(Restrictions.eq("st.abbreviation", abbreviation));
  2. @jeffsheets jeffsheets created this gist Apr 2, 2013.
    27 changes: 27 additions & 0 deletions gistfile1.java
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,27 @@
    /*
    * HQL would look something like this:
    *
    * from Person p join fetch p.addresses address
    * where exists (
    * from Address addr left join addr.state st
    * where addr.personId = p.id
    * and st.abbreviation = :abbreviation
    * )
    */

    DetachedCriteria criteria = DetachedCriteria.forClass(Person.class, "p");

    //addresses is set to lazy=true in hbm.xml file, but we want to pull back all
    //addresses for a Person, so we must make it eager with JOIN
    criteria.setFetchMode("addresses", FetchMode.JOIN);

    DetachedCriteria addressCriteria = DetachedCriteria.forClass(Address.class, "addr");
    addressCriteria.createAlias("state", "st");
    addressCriteria.add(Restrictions.eq("st.abbreviation", abbreviation));
    addressCriteria.add(Restrictions.eqProperty("addr.personId", "p.id"));

    //Finds all Persons that have an Address with state abbreviation of :abbreviation
    criteria.add(Subqueries.exists(addressCriteria.setProjection(Projections.property("addr.id"))));

    //Limit results to first 2000 Persons that have an address matching the given state abbreviation
    List<Person> results = getHibernateTemplate().findByCriteria(criteria, 0, 2000);