Hi, it looks like the optional "WHERE" attribute in Class mapping is ignored if this Class is used as a collection. In this case the "WHERE" attribute should be also added to the Collection mapping as well:
Code:
<map name="States" >
    <key column="CountryID" />
     <index column="Name" type="String"/>
     <one-to-many class="d001.State, d001" />
 </map>
... would ignore any "where" attributes if present in State class mapping.
Code:
<map name="States" where="active=1">
    <key column="CountryID" />
     <index column="Name" type="String"/>
     <one-to-many class="d001.State, d001" />
 </map>
... would work fine.
So some parts of the class mapping for State are ignored in this case? Is it a feature or a bug?