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 assuming that
you are checking if an obects collect is empty or are you looking for
all ojects that empty collections? Either way I would look at the exists
clause.
Dain Sundstrom wrote:
> 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
