<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class entity-name="ccategories" lazy="true" table="Categories">
        <tuplizer class="org.hibernate.bugs.SampleTuplizer" entity-mode="dynamic-map"/>
        <id name="CategoryID" type="int">
            <column length="10" name="CategoryID"/>
        </id>
        <property name="CategoryName" type="string">
            <column name="CategoryName" not-null="true"/>
        </property>
        <property name="Description" type="string">
            <column name="Description"/>
        </property>
        <property name="Picture" type="binary">
            <column name="Picture"/>
        </property>
        <bag name="bagproducts" table="products">
            <key column="CategoryID"/>
            <element column="productname" type="string"/>
        </bag>
        <map name="mapProducts" table="products">
            <key column="CategoryID"/>
            <map-key column="ProductID" type="int"/>
            <element column="productname" type="string"/>
        </map>
        <bag name="bagProductsOrdered" order-by="ProductName" table="products">
            <key column="CategoryID"/>
            <element column="productname" type="string"/>
        </bag>
        <map name="mapProductsOrdered" order-by="ProductID" table="products">
            <key column="CategoryID"/>
            <map-key column="ProductID" type="int"/>
            <element column="productname" type="string"/>
        </map>
    </class>
</hibernate-mapping>

@Override
public boolean isOrdered() {
   return StringHelper.isNotEmpty(getOrder());
}

@Override
public String getOrder() {
   return ordered;
}