Re: [OJB-developers] SQLGenerator

[Henri Y. <ba...@ge...>]

I'm not much of a DB guy, but I am pretty sure we're using the SQL-92 JOIN
syntax in Oracle 9i. I think 8 and before, maybe 8i didn't support that.

On Thu, 2 May 2002, Oleg Nitz wrote:

> 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).
> 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.
> I suppose that generating of join syntax should be delegated to Platform
> implementations.