JDBC Floating point loss of precision

From: <dwhitt_at_csihq.com>
Date: Tue, 11 May 1999 11:27:06 GMT
Message-ID: <7h9464$qhb$1@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

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 06:27:06 CDT