Hello,

I've been trying to get something to work without success. Here's a simple example:

I have two Hibernate classes: A and B. Each has its own table in the database.
A has some attributes, and has a foreign key to B. It does not, however, have a hibernate relationship to B in A's mapping file. Only a foreign key stored as a Long value.

The question is, how can I do a HQL query that selects attributes from both A and B?
I tried something like:

select a from A as a join B as b where a.fkey = b.id

That gives me the exception:

"outer or full join must be followed by path expression..."

How can I do this without adding the association to the Hibernate mapping file?


Thanks!
Chris

Cartesian product and theta-style join on the product:

How do you use an left ou right outer join　that ?

Thanks.
Alain

Not possible.

Is Theta Style outer join possible in latest version of hibernate ?

Nope.

Every day you will see some posts into this forum from developers who needs this functionality.
Hibernate does not support this, openJPA does.

Does anybody know why hibernate doesn't support that?

Thanks in advance,
Pieter