Обсуждение: Bad value for type BigDecimal : Infinity

Поиск
Список
Период
Сортировка

Bad value for type BigDecimal : Infinity

От
Ivan Petrov
Дата:
Hi, I'm using postgres JDBC driver version 42.2.23

Here is my exception


Bad value for type BigDecimal : Infinity; nested exception is org.postgresql.util.PSQLException: Bad value for type BigDecimal : Infinity
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475)
...
Caused by: org.postgresql.util.PSQLException: Bad value for type BigDecimal : Infinity
at org.postgresql.jdbc.PgResultSet.toBigDecimal(PgResultSet.java:3064)
at org.postgresql.jdbc.PgResultSet.toBigDecimal(PgResultSet.java:3073)
at org.postgresql.jdbc.PgResultSet.getNumeric(PgResultSet.java:2491)
at org.postgresql.jdbc.PgResultSet.getBigDecimal(PgResultSet.java:2443)
at org.postgresql.jdbc.PgResultSet.getBigDecimal(PgResultSet.java:406)


What is the right way to debug it? Column name would help...