From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ivan Petrov <capacytron@gmail.com>
Cc: pgsql-jdbc@lists.postgresql.org
Subject: Re: Bad value for type BigDecimal : Infinity
Date: Thu, 08 Jul 2021 15:45:34 -0400
Message-ID: <2039695.1625773534@sss.pgh.pa.us> (raw)
In-Reply-To: <CAEARqsEv43ug8LMqhFjYS9ke9YphvfchtUC=fJp=k5KxGksnDA@mail.gmail.com>
References: <CAEARqsEv43ug8LMqhFjYS9ke9YphvfchtUC=fJp=k5KxGksnDA@mail.gmail.com>
[ redirecting to jdbc list ]
Ivan Petrov <capacytron@gmail.com> writes:
> Hi, I'm using postgres JDBC driver version 42.2.23
> https://mvnrepository.com/artifact/org.postgresql/postgresql/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
> ...
> 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)
I dunno, does BigDecimal have a concept of infinity? If not, this
doesn't seem like something the driver can avoid for you. If it
does, then something needs to be updated to be aware that PG now
supports infinities in type numeric.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, capacytron@gmail.com, pgsql-jdbc@lists.postgresql.org
Subject: Re: Bad value for type BigDecimal : Infinity
In-Reply-To: <2039695.1625773534@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox