File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Beginning Java and the fly likes getDouble() not returning correct data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "getDouble() not returning correct data" Watch "getDouble() not returning correct data" New topic

getDouble() not returning correct data

Jennifer Sohl
Ranch Hand

Joined: Feb 28, 2001
Posts: 455
Hi. I have a column in a table that has data that is defined as Numeric(6,4).
In my java app, all I am trying to do is print this data to std out. When I get the information from the db, I do a getDouble() to retrieve it, and I am getting a result of 1.0E-4 ?? The actual value in the db is .0001. Why isn't this returning .0001?
If I run the SQL statement and don't go through the app, it returns .0001.
What am I doing wrong?
Thanks for any help.
Matthew Vincent

Joined: May 01, 2003
Posts: 8
Just use the following code snippet to help you. Assuming that your variable is called myVal...

Joel McNary

Joined: Aug 20, 2001
Posts: 1815
Just for the record, 1.0E-4 is .0001, in case anyone missed that.

Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
I agree. Here's the link:
subject: getDouble() not returning correct data
Similar Threads
Data file format from new assignment
problem in retrieving data from excel
java.sql.SQLException: No data read
Strange query results using Java, but OK w/SQLSVR Mgmt Studio