Re: jdbc rounding value for numeric fields

Ioana Danes <ioanasoftware@yahoo.ca> writes:
>            ps.setDouble(1,2.6999999999999997);

Don't use setDouble.  float8 to numeric conversion only preserves
DBL_DIG (ie, 15 on standard platforms) decimal digits, since that's
the most that can be fully trusted in a float8 value.

            regards, tom lane