Re: [OJB-developers] SQLGenerator

[Oleg N. <on...@uk...>]

On Friday 03 May 2002 10:29, Jakob Braeuchi wrote:
> hi oleg,
>
> i did the original path expression to build joins and so i'm responsible
> for all it's limitations ;-)
I'm glad to meet a responsible person ;-)

> one issue is the type of the join (LEFT, RIGHT etc.).
> today selection criteria and report queries provides no way to define
> join-type.
> we could define it in the path:
>
> -  konti+.saldo (OUTER)       or in the criteria
> - crit.addGreaterThan("konti.saldo", new Integer(100), OUTER);
>
> do you have other ideas ?
I suppose that in the case of query condition we should always use inner join.
IMHO if one say "saldo > 100" he wouldn't expect to get saldo == null.
Well, in the case of "saldo < 100" it makes more sense :)
I don't know if anyone really need outer joins here. I don't need them.
Outer joins may become useful in some other cases, IMHO they should be 
supported by SQLGenerator.
Anyway INNER JOIN syntax is RDBMS dependent.

Regards,
 Oleg