Re: [OJB-developers] SQLGenerator

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

Thanks Charles,

I wasn't really aware of MS SQL syntax, I just thought that it should be much 
like Sybase ASE, for historical reasons :)

Oleg


On Thursday 02 May 2002 17:37, Charles Anthony wrote:
> MS SQL 7 seems to support SQL-92 JOIN syntax: the following is the syntax
> of the FOR clause from the transact-sql help file...
>
> [ FROM {<table_source>} [,...n] ]
>
> <table_source> ::=
> 	table_name [ [AS] table_alias ] [ WITH ( <table_hint> [,...n]) ]
>
> 	| view_name [ [AS] table_alias ]
> 	| rowset_function [ [AS] table_alias ]
> 	| derived_table [AS] table_alias [ (column_alias [,...n] ) ]
> 	| <joined_table>
>
> <joined_table> ::=
> 	<table_source> <join_type> <table_source> ON <search_condition>
>
> 	| <table_source> CROSS JOIN <table_source>
> 	| <joined_table>
>
> <join_type> ::=
> 	[ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ]
> 	[ <join_hint> ]
> 	JOIN
>
> Cheers,
>
> Charles.
>
> > -----Original Message-----
> > From: Oleg Nitz [mailto:on...@uk...]
> > Sent: 02 May 2002 15:36
> > To: obj...@li...
> > Subject: [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).
> > 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
> >
> > _______________________________________________________________
> >
> > 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
>
> This email and any attachments are strictly confidential and are intended
> solely for the addressee. If you are not the intended recipient you must
> not disclose, forward, copy or take any action in reliance on this message
> or its attachments. If you have received this email in error please notify
> the sender as soon as possible and delete it from your computer systems.
> Any views or opinions presented are solely those of the author and do not
> necessarily reflect those of HPD Software Limited or its affiliates.
>
>  At present the integrity of email across the internet cannot be guaranteed
> and messages sent via this medium are potentially at risk.  All liability
> is excluded to the extent permitted by law for any claims arising as a re-
> sult of the use of this medium to transmit information by or to
> HPD Software Limited or its affiliates.
>
>
>
> _______________________________________________________________
>
> 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