JDBC Types Mapped to Java Object Types

http://docs.oracle.com/javase/1.5.0/docs/guide/jdbc/getstart/mapping.html

http://docs.oracle.com/javase/1.5.0/docs/guide/jdbc/getstart/mapping.html#table1

http://mail-archives.apache.org/mod_mbox/db-ojb-user/200311.mbox/[e-mail]%3E

in Oracle NUMBER is the very universal data type for all kinds of numericvalues. Which jdbc data type you would want to use depends on the actuallystored values. I think the most general mapping is (Oracle)NUMBER ->(JDBC)DOUBLE -> (Java) double.We use the following table for our mapping (but our direction is the otherway round: we come from the Java application and look for an appropriatedatabase data type). But maybe it is useful for you:JDBC Data Type  Oracle Data TypeTINYINT         NUMBER(3)SMALLINT        NUMBER(5)INTEGER         NUMBER(10)BIGINT          NUMBER(20)DOUBLE          NUMBERREAL            NUMBERFLOAT           NUMBERNUMERIC         NUMBERDECIMAL         NUMBER

JDBC Type

Java Object Type

CHAR

String

VARCHAR

String

LONGVARCHAR

String

NUMERIC

java.math.BigDecimal

DECIMAL

java.math.BigDecimal

BIT

Boolean

TINYINT

Integer

SMALLINT

Integer

INTEGER

Integer

BIGINT

Long

REAL

Float

FLOAT

Double

DOUBLE

Double

BINARY

byte[]

VARBINARY

byte[]

LONGVARBINARY

byte[]

DATE

java.sql.Date

TIME

java.sql.Time

TIMESTAMP

java.sql.Timestamp

DISTINCT

Object type of underlying type

CLOB

Clob

BLOB

Blob

ARRAY

Array

STRUCT

Struct or SQLData

REF

Ref

JAVA_OBJECT

underlying Java class