Hibernate version:
Hibernate 3.05

Name and version of the database you are using:
Oracle 9i

Hi,

I want to make a join on 2 objects which don't have any link in mapping files or in tables but have a functional connection.

This is my HQL request:


That's my exception:



I searched in Hibernate doc but I didn't find how to write a "left join" request as in SQL. How can I do?

THX.[/code][/b]

The "LEFT JOIN" syntax for HQL only works for associations.

You can get an arbitrary INNER JOIN in HQL as follows: "FROM Object1 obj1, Object2 obj2 WHERE obj1.prop1 = obj2.prop1", but no left join.

Can you create an association? I.E. <many-to-one column="col1" name="assoc1" class="test.Class1" insert="false" update="false" fetch="select">. This way, the association is not fetched unless you attempt to navigate into it OR you explicitly join.

Curtis ...