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

[swapnil dangore]

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

   
        <bean id="OUT_COLUMN1" class="org.springframework.jdbc.core.SqlOutParameter">
		<constructor-arg index="0" value="COLUMN1" />
		<constructor-arg index="1">
			<value>3</value> //3 represents Decimal
		</constructor-arg>
	</bean>

       //Java code to get the value from output map

      BigDecimal COLUMN1 = (BigDecimal)outMap.get("COLUMN1");
     System.out.println("COLUMN1 value ::: "+COLUMN1.doubleValue());

 

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

[Campbell Ritchie]

There's no such thing as "urgent".