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

On Tue, 07 Jan 2003 12:49:32 +0000, Doug Baroter wrote:

> 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!

Hmm, Java, of course, is a real programming language. I have not checked, but you probably checked to see what the JDBC (2.0?) standard has to say about such column types in a ResultSet?

Cheers,

dmz17 Received on Wed Jan 08 2003 - 21:33:35 CET