Hello Zhe, 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 Regards Max > -----Urspr�ngliche Nachricht----- > Von: Zhe Liu [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 18. November 2003 09:25 > An: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Betreff: JDBC type for Oracle NUMBER fields > > > I am just wondering whether anybody has some best practice > experience on how to map Oracle NUMBER fields to the JDBC > type in repository and what java type should be used for the > corresponding value object properties? > > Thanks, > Zhe > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
