Skip site navigation (1) Skip section navigation (2)

jdbc rounding value for numeric fields

From: Ioana Danes <ioanasoftware(at)yahoo(dot)ca>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jdbc rounding value for numeric fields
Date: 2009-05-25 15:16:46
Message-ID: 185722.54227.qm@web45103.mail.sp1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Everyone,

I have a problem with a prepare statement rounding the numeric fields.

I have 2 inserts into a numeric field. The first insert is using an update statement and the second one a prepared statement.
It looks like the prepared statement is doing a rounding on the inserted  value....
 
First insert:
          sql.executeUpdate("insert into jdbc_demo values (2.6999999999999997)");
Postgresql log for the first insert:
          insert into jdbc_demo values (2.6999999999999997)
The value in the database:
          2.6999999999999997
  
Second Insert:
          PreparedStatement ps = db.prepareStatement("insert into jdbc_demo values (?)");
          ps.setDouble(1,2.6999999999999997);
          ps.executeUpdate();
          ps.close();
Postgresql log for the second insert:
           insert into jdbc_demo values ($1) parameters: $1 = '2.6999999999999997'
The value in the database:
           2.7
 
Does anyone know why this is happening and if is a jdbc or postgres issue?

Thanks a lot,
Ioana Danes



      __________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/


pgsql-jdbc by date

Next:From: Ioana DanesDate: 2009-05-25 15:48:06
Subject: Re: jdbc rounding value for numeric fields
Previous:From: Tom LaneDate: 2009-05-25 15:15:49
Subject: Re: jdbc rounding value for numeric fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group