Re: [OJB-developers] SQLGenerator

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

hi thomas, oleg,

i implemented only sql-92 join syntax, because the join clause is cleanly
separated from the FROM- and the WHERE-clause. i agree that this may be a
candidate for platform specific code but i also think that 92 is a long time
ago...

jakob

----- Original Message -----
From: "Mahler Thomas" <tho...@it...>
To: "'Oleg Nitz'" <on...@uk...>;
<obj...@li...>
Sent: Thursday, May 02, 2002 5:13 PM
Subject: AW: [OJB-developers] SQLGenerator


> Hi Oleg,
>
> > -----Ursprungliche Nachricht-----
> > Von: Oleg Nitz [mailto:on...@uk...]
> > Gesendet: Donnerstag, 2. Mai 2002 16:36
> > An: obj...@li...
> > Betreff: [OJB-developers] SQLGenerator
> >
> >
> > Hi,
> >
> > I started to work on the "OQL Self Joins" issue
> >
> > http://sourceforge.net/forum/forum.php?thread_id=655922&forum_id=43066
> > so I am looking at the SQLGenerator stuff, and its
> > capabilities seem a bit
> > restricted. Please, confirm the following statements
> > 1) OJB supports only databases that support SQL-92 JOIN
> > syntax (INNER JOIN,
> > LEFT OUTER JOIN).
>
> Right !
>
> > Thus Sybase ASE and MS SQL Server aren't supported, since
> > they don't support
> > SQL-92 JOIN syntax AFAIK. Does Oracle support it? Not sure.
>
> AFAIK Oracle 8i doesn't but 9i does.
>
> > I suppose that generating of join syntax should be delegated
> > to Platform
> > implementations.
>
> I agree.
>
> > 2) OJB doesn't support queries on columns with path longer than 1,
> > i.e. it successfully handles
> >             crit.addEqualTo("source.name", "A");
> > but fails on
> >             crit.addGreaterThan("source.location.x", new Integer(0));
> >
>
> Oh, I thought this was possible. If this does not work it should be fixed
!
>
> > I can try to solve these issues too.
>
> That would be great !
>
> Thanks,
>
> Thomas
>
> >
> > 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
> >
>
> _______________________________________________________________
>
> 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
>