Another JDBC driver bug (a piece of *)

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! Received on Tue Jan 07 2003 - 21:49:32 CET