Re: [OJB-developers] SQLGenerator

[Jakob B. <jbr...@ho...>]

hi oleg,

you know, in switzerland the responsible persons get the real huge salaries,
even if they do a bad job ;-)

SQLGenerator has no function to automatically detect an OUTER join. But
JoinInfo innerclass could generate the appropriate SQL. So we need a way to
explicitely use OUTER joins and i prefer to define it in the criteria.

regards
jakob

----- Original Message -----
From: "Oleg Nitz" <on...@uk...>
To: <obj...@li...>
Sent: Friday, May 03, 2002 11:53 PM
Subject: Re: [OJB-developers] SQLGenerator


> 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
>
>
> _______________________________________________________________
>
> Have big pipes? SourceForge.net is looking for download mirrors. We supply
> the hardware. You get the recognition. Email Us: ban...@so...
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>