Hibernate version:

2.1.6

Name and version of the database you are using:

Oracle 9i


I have a question about HQL joins. The ANSI SQL join syntax allows one to specify multiple conditions for specifying a join, using the following syntax:

left outer join table1 table1 on table0_. id=table1_.id and table1_.active_flag = 'Y'

So far in Hibernate, I have seen that you can define a relationship between two objects/tables with a key field.

<set name="incidentContractRelationships"
lazy="true"
inverse="true">
<key column="contract_id"/>
</set>

I know that you can specify a where clause as part of this relationship:

<set name="incidentContractRelationships"
lazy="true"
inverse="true"
sort="unsorted"
where="active_flag = 'Y'">

<key column="contract_id"/>
</set>

However, if you do this, then the where clause will be applied in the where clause, not in the join clause. This will not give you the correct results.

Is there any way to have Hibernate specify multiple conditions for joining two tables?

Thanks!
Patrick

OK after searching the forum, I found the following post:

http://forum.hibernate.org/viewtopic.php?t=933639

It appears that Christian has already answered this question (although I did not find this in the FAQ anywhere....)

Will we have this capability in Hibernate 3?

Thanks!
Patrick

Likely