[OJB-developers] SQLGenerator

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

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. 
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));

I can try to solve these issues too.

Regards,
 Oleg