Hibernate version: 3.2

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


Hi team,

In our application we need to fetch the data from two tables that don't have any constraints (primary key,foreign key). Also we need to use left outer join with them. We have "Hibernate in action" for reference. In which, I have read that "It's not possible in Hibernate to outer join two tables that don't have a mapped association".

Is there any other way to make left outer with above mentioned tables?

We don't have the permission to change the structure of the database. Because it is a migration project from vb to j2ee.


thanks in advance,
Tinu