Re: Another JDBC driver bug (a piece of *)

qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301071249.68e55457_at_posting.google.com>...
> Check out this simple query against an Oracle9i db:
> select *
> from OE.CUSTOMERS
> where rowNum <100 + 1
> order by CUSTOMER_ID DESC
>
> SQL+Plus type of SQL client can handle it while interface via JDBC
> driver for Oracle9i fails (sorry don't know its version, likely the
> most recent one).
>
> Possible cause:
> some columns uses UDDT (User Defined DataType), e.g. cust_address uses
> a UDDT named "cust_address_typ", I guess when SQL+Plus detects it it
> does translation/conversion while the "simple-minded" JDBC driver just
> throws up her hand, what a crying baby!

It would be helpfull if you provide the JDBC error message before rudely accusing it of failure.

/Rauf Sarwar Received on Wed Jan 08 2003 - 04:35:02 CET