JDBC Floating point loss of precision

From: <dgwhitt_at_my-dejanews.com>
Date: Fri, 07 May 1999 14:59:46 GMT
Message-ID: <7guv4u$ar9$1_at_nnrp1.deja.com>

Does anyone know of a problem trying to retrieve floating point data from the Oracle database using JDBC Thin client? Any field that is a data type NUMBER (without specified precision/scale) or FLOAT is not being retrieved correctly. The same code was modified to use an ODBC driver and the data is retrieved correctly.

For example:

Datatype      Value  Retrieved data
NUMBER        0.005        0
FLOAT         0.005        0
NUMBER(3,3)   0.005        .005

Any suggestions?
Thanks,
Dianna Whitt

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 16:59:46 CEST