Join table with DetachedCriteria

[zabet tyan]

Hi

I am using detachedCriteria to retrieve something from db.

I have notification hbm as follows:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping
	package="ca.server.databeans">
	<class name="Notification" table="V_NO">
		
		<id name="Id" type="java.lang.Long" column="ID">
			<generator class="sequence">
				<param name="sequence">SQ_NO</param>
			</generator>
		</id>
		<property name="Subject" column="SUBJECT" type="string"
			not-null="true" length="100" />
		<property name="Body" column="BODY" type="string" not-null="true"
			length="500" />
		<property name="NotType" column="NOT_TYPE">
			<type name="varchar_enum">
				<param name="enumClassName">ca.common.NotificationTypeEnum</param>				   
			</type>
		</property>		
		<property name="PersonId" column="PERSON_ID" type="java.lang.Long"
			not-null="true"/>
	</class>
</hibernate-mapping>

Person is not mapped directly to notification. it has the id only.

the person has a displayName field that I want to get and return as part of my Projection.

However I am not sure how to join the tables using DetachedCriteria to get the field.


Please note I cannot change the database model or hbm files.


Any help would be greatly appriciated,