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

Question

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]

Looks like you number is to big for an int. Use a Long instead — Jens
– Jens, Commented Oct 9, 2017 at 9:16
Thanks for suggestions. Already using Long in the outputMapper. The DB column is Number(18), the generated number by the store proc is of the 13 digits. Up to 12 digits its working, but when stored proc startd producing 13 digit number the code is failing. — Rauthan
– Rauthan, Commented Oct 9, 2017 at 12:39

Mostch Romi · Accepted Answer · 2017-10-09 10:37:28Z

7

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.

answered Oct 9, 2017 at 10:37

Mostch Romi

5411 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rauthan Over a year ago

The column data type is NUMBER(18) , while the generated number is of 13 digits.Can you please suggest ?

Somaye Kafi · Accepted Answer · 2020-07-21 05:01:10Z

1

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

answered Jul 21, 2020 at 5:01

Somaye Kafi

112 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related