Search code examples
springupgrade

Numeric overflow error after upgrading to Spring 3.1.0 & Java 17


Caused by: java.sql.SQLException: Numeric Overflow
    at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4161)
    at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:131)
    at oracle.jdbc.driver.GeneratedStatement.getInt(GeneratedStatement.java:171)
    at oracle.jdbc.driver.GeneratedScrollableResultSet.getInt(GeneratedScrollableResultSet.java:269)
    at com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java)
    at org.hibernate.type.descriptor.jdbc.IntegerJdbcType$2.doExtract(IntegerJdbcType.java:88)
    at org.hibernate.type.descriptor.jdbc.BasicExtractor.extract(BasicExtractor.java:44)
    at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.readCurrentRowValues(JdbcValuesResultSetImpl.java:267)
    ... 157 common frames omitted

Please suggest some solution


Solution

  • I was getting the same issue but it worked after upgrading to Spring Boot 3.1.1 which was released recently.