Very Computer

My suspicion is that there are many more java.sql.Types that Oracle
types, and that in most cases there is a many-to-one relationship
between java.sql.Types and Oracle types.

In effect, I would like to be able to read from Oracle through JDBC a
java.sql.ResultSet and receive java.sql.Types other than 1,2,12,and 93
(CHAR, NUMERIC, VARCHAR, and TIMESTAMP). Is this impossible?

Sent via Deja.com http://www.deja.com/
Before you buy.

This is explained in detail in Oracle 8i JDBC Developer's Guide and
Reference.

Ch 3 - Basic Features - Datatype mappings
Ch5 - Oracle Type Extentions

is probably what you want.

Hope this helps,

Bob Beauchemin

Quote:> I would like to find a reference table which shows all the Oracle
> datatypes and their corresponding int-valued java.sql.Types.

> My suspicion is that there are many more java.sql.Types that Oracle
> types, and that in most cases there is a many-to-one relationship
> between java.sql.Types and Oracle types.

> In effect, I would like to be able to read from Oracle through JDBC a
> java.sql.ResultSet and receive java.sql.Types other than 1,2,12,and 93
> (CHAR, NUMERIC, VARCHAR, and TIMESTAMP). Is this impossible?

> Sent via Deja.com http://www.deja.com/
> Before you buy.