This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 43368
    
  32
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
 
jQuery in Action, 3rd edition