I've got a critical bug to fix for a sick colleague who used hibernate, which is new to me. A developers dream. ; )

The problem is that I need to put a join condition in a Criteria object. I know it's easy when using HQL, but I can't find any reference to it in the Criteria API or documentation.

This is what I need to get:


The left outer join is easy, a condition in the where clause is easy, but how do I specifiy "es.ENABLED='Y'" in my join condition??

My current code doesn't work as hibernate says it has no reference to eventsource:

But if I add a reference to eventsource in the criteria, he adds the restriction in the where clause instead of condition.

How should I solve this??

I can solve it as follows, but it's not a very pretty nor typesafe solution:



This will work as long as there are no other 'enabled' columns on the other tables.

For some odd reason, if I add a normal Restriction on the enabled field, hibernate changes the outer join to an inner join. : /

ouwenbelg --


Can you post the hibernate mapping files? If i see them, i should be able to show you how to write a Criteria for the association.

if not here some info to get you started maybe:

Basically there must be a defined association EVENTSOURCE table and the other table you are trying to join on.

Using the association you can do a:



Though you may have to qualify the "enabled" column name with the associationPath prefix, but maybe not: check the generated SQL to be sure.

Hope that helps.

-B[/i]

Thanks for the useful tip, panth13, I forgot about the xml file.



Looking at the hibernate documentation, it should be possible to add a restriction on the many-to-one relation with eventsource, using the "formula" attribute.

ouwenbleg--

The following should work:



Hope that helps!

-B

Thanks! Your example had some flaws (outer join, not inner join), but it did help me find the solution:



problem solved :)