Numeric overflow Exception in java JDBC
As the data in your DB is Number(11)
, this will not fit into an Integer.
Try a Long and rs.getLong(15)
;
Most likely you do not perform any mathematical operations with that "numbers". Since you do not treat them as numbers, but as identifiers. You should use Java type BigDecimal
. This is a type which is most similar to Oracle datatype NUMBER
. Or you can also use datatype provided by jdbc drivers oracle.sql.NUMBER
.