File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Urgent help - DB2 type 4 driver returns 0E-8 for decimal value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Urgent help - DB2 type 4 driver returns 0E-8 for decimal value" Watch "Urgent help - DB2 type 4 driver returns 0E-8 for decimal value" New topic
Author

Urgent help - DB2 type 4 driver returns 0E-8 for decimal value

swapnil dangore
Ranch Hand

Joined: Jun 05, 2006
Posts: 46
Hi Ranchers,
We are using DB2 type 4 driver and Spring JDBC for DB communications. We have a column "COLUMN1" defined as DECIMAL(15,2).
The Spring-defination for this column is as


After executing stored procedure, when I try to get value for "COLUMN1" from output map , it returns me "0E-8".

What is most annoying is,it returns me "0E-8" , whether column value is "0.000" or "1234.56" or "56673.67".

Bottom line is , I am always getting "0E-8".

Please, let me know if you need more input.

Thanks in advance


Cheers<br />-------------<br />Swapnil<br /> <br />SCJP5-81%<br /> <br />"Dictionary is the only place where Success come before Work"
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38107
    
  22
There's no such thing as "urgent".
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Urgent help - DB2 type 4 driver returns 0E-8 for decimal value
 
Similar Threads
java.lang.NoClassDefFoundError: java/util/concurrent/ConcurrentSkipListMap
use a bean with a constructor in spring
If Someone Would Help Me to Understand a Spring Configuration Snippet
different behavior with db2 driver, type 4
problens in spring CustomDataEditor!