Saturday, August 18, 2001 10:34 AM
Subject: Re: [JBoss-dev] JDBC SQL Extensions
> Dain Sundstrom wrote:
> > Do any other popular databases not support exists?
> No, only MySQL and mSQL don't support, all other databases support
> nested queries.
>
> Oleg
>
Dain Sundstrom wrote:
> Do any other popular databases not support exists?
No, only MySQL and mSQL don't support, all other databases support
nested queries.
Oleg
___
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists
aturday, August 18, 2001 5:14 AM
Subject: Re[2]: [JBoss-dev] JDBC SQL Extensions
> Hi Dain,
>
> Be aware that MySQL doesn't support nested queries.
> Outer joins is more portable solution IMHO.
> BTW in Castor JDO we have "database drivers", which map OUTER JOINs
> and
Hi Dain,
Be aware that MySQL doesn't support nested queries.
Outer joins is more portable solution IMHO.
BTW in Castor JDO we have "database drivers", which map OUTER JOINs
and FOR UPDATE to all popular databases.
Oleg
Dain Sundstrom wrote:
> Issue 2: IS EMPTY function. How should I map the fol
).
-dain
- Original Message -
From: "David Jencks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 4:46 PM
Subject: Re: [JBoss-dev] JDBC SQL Extensions
> On 2001.08.17 16:31:43 -0400 Dain Sundstrom wrote:
> > Sorry for the confu
On 2001.08.17 16:31:43 -0400 Dain Sundstrom wrote:
> Sorry for the confusion. There are two issues here.
>
> ==
>
> Issue1: use of the {fn concat(str1, str2)} style functions.
>
> Solution: use fn style functions as default but have override in xm
Dain Sundstrom wrote:
> Sorry for the confusion. There are two issues here.
>
> ==
>
> Issue1: use of the {fn concat(str1, str2)} style functions.
>
> Solution: use fn style functions as default but have override in xml like:
> CONCAT (?
PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] JDBC SQL Extensions
Sorry for the confusion. There are two issues here.
==
Issue1: use of the {fn concat(str1, str2)} style functions.
Solution: use fn style functions as default but have override
Sorry for the confusion. There are two issues here.
==
Issue1: use of the {fn concat(str1, str2)} style functions.
Solution: use fn style functions as default but have override in xml like:
CONCAT (?1, ?2)
or some thing simmilar.
I doubt you can rely on any of these for portability.
Can you make it so there is a db-specific plugin for each db? I think this
would be simpler than trying to dynamically figure out what is supported
from the databasemetadata.
Isn't it amazing that Oracle claims sql compliance with their "uni
When it comes to the outer joins I would be vary careful if not try to
avoid them altogether. The SQL spec is washy at best and I believe that
each vendor does it a little differntly , PostgeSQL only added outer
joins in version 7.1.
The IS EMPTY cluase ... after reading the spec are they as
n such a way that a user can take a
> real-world application and just move it from one database to the next.
>
> For that reason, I think you're going to need some mapping from EJB-QL to
> the various SQL dialects.
>
> Cheers
>
> -Original Message-
> Fr
--Original Message-
From: Dain Sundstrom [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 3:39 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] JDBC SQL Extensions
consice does not equal understandable
for example
a?b:c
-dain
- Original Message -
From: "Jay Walters&quo
consice does not equal understandable
for example
a?b:c
-dain
- Original Message -
From: "Jay Walters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 2:16 PM
Subject: RE: [JBoss-dev] JDBC SQL Extensions
> Not to be too much in or
3:11 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-dev] JDBC SQL Extensions
all JDBC experts,
Is it common for the JDBC drivers to support the SQL Extension functions?
http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec/jdbc-spec.frame11.html
I specifically need the functions: concat, substring, locate, l
all JDBC experts,
Is it common for the JDBC drivers to support the SQL Extension functions?
http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec/jdbc-spec.frame11.html
I specifically need the functions: concat, substring, locate, length, abs,
and sqrt.
I'm planing on mapping these to {fn concat('s
16 matches
Mail list logo
