objectbridge-developers

RE: [OJB-developers] SQLGenerator

[Charles A. <cha...@hp...>]

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.

Re: [OJB-developers] SQLGenerator

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

On Saturday 04 May 2002 11:42, you wrote:
> hi oleg,
>
> you know, in switzerland the responsible persons get the real huge
> salaries, even if they do a bad job ;-)
>
:)

> SQLGenerator has no function to automatically detect an OUTER join. But
> JoinInfo innerclass could generate the appropriate SQL. So we need a way to
> explicitely use OUTER joins and i prefer to define it in the criteria.

I don't feel that OUTER joins are necessary now.
On the other hand, I don't have arguments against them.
Please tell me if you are going to do something around SQLGenerator soon.
I meant to use them for polymorphism of the "3rd" type which is now not
supported by OJB (one table for base class, one table for each extending
class, the latter contains only proprietary fields of the extending class).

Regards,
 Oleg

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