AW: [OJB-developers] SQLGenerator

[Mahler T. <tho...@it...>]

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
>