I've an abstract class Content, which has a few subclasses extending from it: Video, Photo and Collection.
Using the criteria API I found out how to query all Content instances (doesn't matter if it's a Video, Photo or Collection):
I also found out how to query for a specific content type, like querying only for Videos:
<class name="content.Content" table="content" lazy="true">
<cache usage="read-write"/>
<id name="contentid" type="java.lang.Integer">
<generator class="sequence">
<param name="sequence">content_contentid_seq</param>
</generator>
</id>
<property name="views" not-null="true" />
<property name="dateadded" not-null="true" />
...
<joined-subclass name="content.video.Video"
table="video">
<key column="contentid" foreign-key="true" not-null="true"
unique="true">
</key>
<property name="videoid" unique-key="true" not-null="true"
insert="false" update="false">
</property>
<property name="url" not-null="true" />
...
</joined-subclass>
<joined-subclass name="content.photo.Photo"
table="photo">
<key column="contentid" foreign-key="true" not-null="true"
unique="true">
</key>
<property name="photoid" unique-key="true" not-null="true"
insert="false" update="false">
</property>
<property name="recorddate" />
...
</joined-subclass>
<joined-subclass name="content.collection.Collection"
table="collection">
<key column="contentid" foreign-key="true" not-null="true"
unique="true">
</key>
<property name="collectionid" unique-key="true" not-null="true"
insert="false" update="false">
</property>
<property name="publicCollection" column="public"/>
...
</joined-subclass>
</class>
Login
FAQ
Search
