I have two tables transOrg and transEnt
both having the idEnt

How is supossed that I've to make the LEFT OUTER JOIN between the two tables

transOrg.hbm.xml

<hibernate-mapping>
<class name="com.mysystem.dto.transOrg" table="TRANS_TYPE_ORG" schema="TRANS_ADM">
<composite-id name="id" class="com.mysystem.dto.transOrgId">
<key-many-to-one name="transOrg" class="com.mysystem.dto.transOrg">
<column name="ID_ENT" length="5" />
</key-many-to-one>
</composite-id>
</class>
</hibernate-mapping>


myaction-servlet.xml

<entry key="orgList">
<bean parent="baseHibernateAdapter">
<property name="hql">
<value>
FROM
com.mysystem.dto.transOrg AS to,
com.mysystem.dto.transEnt AS te
LEFT OUTER JOIN
to.id.transOrg.transEnt.idEnt = te.id.transEnt.idEnt
</value>
</property>
</bean>
</entry>


this produces a NullPointer Exception
what I am missing ?

cheers,
teixi.