CODEWITHSUNDEEP
javajdbc
Rauthan
Rauthan

Reputation: 61

java JDBC : Caused by: java.sql.SQLException: Numeric Overflow

Hi I am getting the bwlow error while running my JAVA code

Caused by: java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4380) ~[ojdbc-11.2.0.2.0.jar:11.2.0.2.0]
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:111) ~[ojdbc-11.2.0.2.0.jar:11.2.0.2.0]
at oracle.jdbc.driver.NumberCommonAccessor.getObject(NumberCommonAccessor.java:3263) ~[ojdbc-11.2.0.2.0.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CVarnumAccessor.getObject(T4CVarnumAccessor.java:303) ~[ojdbc-11.2.0.2.0.jar:11.2.0.2.0]
at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:2049) ~[ojdbc-11.2.0.2.0.jar:11.2.0.2.0]
at oracle.jdbc.driver.OracleCallableStatementWrapper.getObject(OracleCallableStatementWrapper.java:815) ~[ojdbc-11.2.0.2.0.jar:11.2.0.2.0]

Upvotes: 1

Views: 34480

Answers (2)

Somaye Kafi
Somaye Kafi

Reputation: 11

I have the same problem. I use " Types.BIGINT" instead of "Types.NUMERIC" in java code. and the problem solved

Upvotes: 1

Mostch Romi
Mostch Romi

Reputation: 541

In Oracle, if you store numeric data and this data is out of range from column data type then you got this type of Exception.

Example- if you have a column of INTEGER(NUMBER) type and you store data greater than 2,147,483,647 then its Numeric Overflow.

Upvotes: 7

Related Questions