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/%3CJEEKLIHGGBBGOFKFOLDDMECCCAAA.zliu@getsilicon.net%3E

in Oracle NUMBER is the very universal data type for all kinds of numeric
values. Which jdbc data type you would want to use depends on the actually
stored 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 other
way round: we come from the Java application and look for an appropriate
database data type). But maybe it is useful for you:

JDBC Data Type  Oracle Data Type
TINYINT         NUMBER(3)
SMALLINT        NUMBER(5)
INTEGER         NUMBER(10)
BIGINT          NUMBER(20)
DOUBLE          NUMBER
REAL            NUMBER
FLOAT           NUMBER
NUMERIC         NUMBER
DECIMAL         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