Criteria with Join

pat79 · **Posted:** Tue Dec 05, 2006 12:20 pm

Hi,

i've the following three classes:

I'd like to recieve the featuresCategories with populated List of features. But only this features which are specified for a ProductType.
Notebook --> HDD Capacity, clock rate
Monitor --> weight

this is my idea:

Code:

Criteria crit = getSession().createCriteria(FeatureCategory.class)
   .setFetchMode("features", FetchMode.JOIN)
   .createCriteria("features")
   .createCriteria("productType")
   .add( Expression.eq("id", 10 ) );
return new HashSet(crit.list());

It works, but returns me always the whole list of features, not the specific ones for productType = 10.

Any ideas?

Thanks in Advcance,
Patrick

halconGT · **Posted:** Tue Dec 05, 2006 2:21 pm

just my two cents...
are you using any old version of hibernate. Try using Restrictions rather Expression.
Could you post your entire POJOs?

pat79 · **Posted:** Mon Dec 11, 2006 11:56 am

Hi,

i'm using hibernate 3.1.3.
here are my pojos or rather hbm's:
Feature

Code:

<hibernate-mapping package="foo.model">
    <class name="Feature">
        <id name="id" type="integer" />
   <property name="name" type="string"/>
   <many-to-one name="productType" 
             class="ProductType" 
             cascade="none"
             not-null="true"
             column="product_type_fk"
        lazy="false" />
        <many-to-one name="featureCategory" 
       class="FeatureCategory" 
            cascade="none"
            column="feature_category_fk" />
    </class>
</hibernate-mapping>

FeatureCategory

Code:

<hibernate-mapping package="foo.model">
    <class name="FeatureCategory">
        <id name="id" type="integer"/>
        <property name="name" type="string"/>
        <set name="features" 
             inverse="true"
             cascade="save-update">
            <key column="feature_category_fk"/>
            <one-to-many class="Feature" />
        </set>
    </class>
</hibernate-mapping>

ProductType

Code:

<hibernate-mapping package="foo.model">
   <class name="ProductType">
      <id name="id" type="integer" />
      <property name="name" type="string" />
      <set name="features"
                        inverse="true" cascade="all-delete-orphan">
         <key column="product_type_fk" on-delete="cascade"/>
         <one-to-many class="Feature"/>
      </set>
      </class>
<hibernate-mapping>

Thanks, Patrick

halconGT · **Posted:** Thu Dec 14, 2006 10:16 am

Hi again, for your mapping resources, I've understood You have any bi-directional many-to-one association between features and featuredCategories, but I think if You want retrieve featuredCategories and constrained associated features, You just must add featuredCategories to Criteria API, instead to add features and productTypes.

Thanks