Not to be too much in oracle's defense, but their proprietary outer join
syntax is much more concise. I think you will need to do mapping onto the
various vendor's syntax...
-----Original Message-----
From: Dain Sundstrom [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 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, length, abs,
and sqrt.
I'm planing on mapping these to {fn concat('str1', 'str2')} style functions.
If it is not common to support these fuctions I'll write a function map spec
in the xml.
Also, do most vendors support the {oj outer-join} syntax like:
SELECT *
FROM {oj order LEFT OUTER JOIN line_item ON
order.ordernumber=line_item.ordernumber}
I think I need this to support the IS EMPTY operator in queries like:
SELECT OBJECT(o)
FROM Order o
WHERE o.lineItems IS EMPTY
Thanks for any help
-dain
P.S. I just found some docs that say that Oracle drivers do not support any
of these "portability features" (my words). Does anyone find this
supprising? (I'll keep my feelings on this to my self). Any way, if it is
true, I'll implement this the hard way after I get the easy way working.
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
