[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2181) extra join conditions in mapping files

[Matthias Bayer (JIRA)]

extra join conditions in mapping files
--------------------------------------

         Key: HHH-2181
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2181
     Project: Hibernate3
        Type: Improvement

    Reporter: Matthias Bayer


Allow extra join conditions to be specified in mapping file. 
The Criteria API considers this additional join condition.
Benefit is the central declaration.

<hibernate-mapping>
   <class name="de.mba.MyClass"
      table="MyTable">
      <id name="poi" type="string">
         <column name="POI" length="22" />
         <generator class="assigned" />
      </id>
      <property name="lupdDatetime" type="timestamp">
         <column name="LUPD_DATETIME" length="26" />
      </property>
      <property name="lupdProcess" type="string">
         <column name="LUPD_PROCESS" length="30" />
      ...
     
      <many-to-one name="assoc1"
         class="de.mba.MyAssoc"
         insert="false" update="false" not-found="ignore">
         <column name="POI" />
         
         //possibility to add extra join condition
         ???
      </many-to-one>
     
   </class>
</hibernate-mapping> 


select
*
from
a as a
left outer join b as b
on a.id = b.id
//problem additional join condition
and b.type='XY'
where
...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira