"WHERE" condition is ignored when mapping to a collection

the1 · **Joined:** Wed May 15, 2013 8:48 am **Posts:** 1

I have a relationship of one department to many students expressed as following:

Student

Code:

<hibernate-mapping>
  <class name="com.example.Student" table="STUDENTS" where="active = 'Y'">
  ...
  </class>
</hibernate-mapping>

Department

Code:

<hibernate-mapping>
  <class name="com.example.Department" table="DEPARTMENTS">
    
    ...
    
    <set name="students>
      <one-to-many class="com.example.Student" />
    </set>

  </class>
</hibernate-mapping>

When I run this code, a department returns all students including ones where active != 'Y' (it disregards the information in the student mapping). Is this expected behaviour? I thought that the where condition on the student mapping would force only the active ones to be returned. I am using 3.2.5.

shynate26 · **Posted:** Fri May 17, 2013 6:09 am

Could you try below two solutions,.

1) Adding class level filter in the child mapping xml.
2) Adding Set level filter in Parent mapping xml.