Oracle version? JDK version? Oracle JDBC driver version? Did you
try with the latest JDBC driver (9.2.0.2/9.0.2.2 as far as I know?)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Joy Hsu" <jhsu_at_informatica.com> wrote in message
news:3e420c9e.0303041828.638e3f94_at_posting.google.com...
> Hi,
>
> I'm using java.sql.DatabaseMetaData.nullsAreSortedHigh() to check if
> the nulls are sorted as the highest values, but the method seems to
> return the wrong value : false. It should be true since Oracle has
> NULLS LAST as the default for ascending order. The SQL I have is like
> 'Select field FROM table ORDER BY 1' and the null values are at the
> end of the returned resultset. Anyone has experience using this method
> or knows why I got the wrong value? or is there some other way to get
> this info?
>
> I don't want to use NULLS FIRST/LAST because we have different
> databases to support. It would be easier if I can get this info in
> database metadata.
>
> Thanks,
> Joy
Received on Wed Mar 05 2003 - 10:26:28 CST
