RE: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue

When I run the select statement, I am getting different data…

What could be causing this?

Please note, when I change my driver to older version, then I don’t see this issue.

From: Andreas Joseph Krogh <andreas@visena.com>
Sent: Tuesday, October 20, 2020 11:49 AM
To: Thangavel, Parameswaran
Cc: pgsql-jdbc@postgresql.org
Subject: Sv: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue

Hi Team,

 

I am using postgresql version 9.4.1. We are in the process of upgrading to PostgreSQL 10.

 

While doing so, we have upgraded the JDBC postgres driver from 9.1-901.jdbc4 to 42.2.5 Post the upgrade we are facing the issue with data integrity where the numeric value is getting rounded off.

 

Scenario:

I am trying to insert a value (float datatype in Java) and in DB it is represented as Numeric.

 

When I try to store, "1234567" the value is stored as "1234570".