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