Usually when you see such an error — Numeric Overflow SQL error code 17026 in your JAVA application code, it means the data type used in the java code is not bigger enough to hold the result data fetched.
Oracle’s Java Developer guide has a mapping table called Java Type to SQL Type Mappings:
| Java Type | Java DB, Derby, CloudScape | Oracle | DB2 | Sybase | MS-SQL Server | MySQL Server |
|---|---|---|---|---|---|---|
| boolean, java.lang.Boolean | SMALLINT | NUMBER(1) | SMALLINT | BIT | BIT | TINYINT(1) |
| int, java.lang.Integer | INTEGER | NUMBER(10) | INTEGER | INTEGER | INTEGER | INTEGER |
| long, java.lang.Long | BIGINT | NUMBER(19) | INTEGER | NUMERIC(19) | NUMERIC(19) | BIGINT |
| float, java.lang.Float | FLOAT | NUMBER(19,4) | FLOAT | FLOAT(16) | FLOAT(16) | FLOAT |
| double, java.lang.Double | FLOAT | NUMBER(19,4) | FLOAT | FLOAT(32) | FLOAT(32) | DOUBLE |
| short, java.lang.Short | SMALLINT | NUMBER(5) | SMALLINT | SMALLINT | SMALLINT | SMALLINT |
| byte, java.lang.Byte | SMALLINT | NUMBER(3) | SMALLINT | SMALLINT | SMALLINT | SMALLINT |
| java.lang.Number | DECIMAL | NUMBER(38) | DECIMAL(15) | NUMERIC(38) | NUMERIC(28) | DECIMAL(38) |
| java.math.BigInteger | BIGINT | NUMBER(38) | BIGINT | NUMERIC(38) | NUMERIC(28) | BIGINT |
| java.math.BigDecimal | DECIMAL | NUMBER(38) | DECIMAL(15) | NUMERIC(38) | NUMERIC(28) | DECIMAL(38) |
As the mapping table above shows, to fetch data and store it from a column with Oracle data type NUMBER(10) , you need to at least define a variable type with int and use getInt of ResultSet interface.
Sometimes it still is not enough because in Oracle, NUMBER(10) means 10 digits with precision 10 and scale 0, the value range stored in such a column could be much larger than Java int type which rangs from -2^31 ~ 2^31 -1 can hold. That’s because internally
“Oracle Database stores numeric data in variable-length format. Each value is stored in scientific notation, with 1 byte used to store the exponent and up to 20 bytes to store the mantissa. The resulting value is limited to 38 digits of precision. Oracle Database does not store leading and trailing zeros. For example, the number 412 is stored in a format similar to 4.12 x 102, with 1 byte used to store the exponent(2) and 2 bytes used to store the three significant digits of the mantissa(4,1,2). Negative numbers include the sign in their length.” — from Oracle Concepts.
So to safely handle NUMBER(10), it’s better to suggest your JAVA devloper to use the JAVA type long instead of the type int and use the method getLong accordingly.
JoeLi's TechLife 