NumberFormatException for Double-Field

[2002 JI Open Discussion]

By: Torsten M  r - tm0815

NumberFormatException for Double-Field

2003-03-27 06:07

Hello,

 

when I try to run a simple report containing Double-Fields I receive the following Exception (possibly due

to my default Locale de_DE):

 

java.lang.NumberFormatException: For input string: "-13,0"

at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

at java.lang.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1213)

at java.lang.Double.valueOf(Double.java:184)

at java.lang.Double.<init>(Double.java:259)

at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:190)

at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:711)

at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:158)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:463)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:373)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)

at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:737)

at JasperXmpl.main(JasperXmpl.java:54)

 

A workaround could be the following patch in JRResultSetDataSource#getgetFieldValue(JRField):

 

else if (clazz.equals(java.lang.Double.class))

{

// objValue = resultSet.getString(field.getName());

// if(resultSet.wasNull())

// {

// objValue = null;

// }

// else

// {

// objValue = new Double((String)objValue);

// }

 

objValue = new Double(resultSet.getDouble(field.getName()));

if(resultSet.wasNull())

{

objValue = null;

}

 

}

 

Is there a reason for the implementation commented out in the above snippet?

 

Thanks

 

Torsten Mueller

[trivolta]

I was worndering if you found a solution to this problem. Recently I got the same error.

 

I happens for very long reports and as a result sevaral pages, beyond that point, get corrupted.

Only the lines apprear and some random static text appears.

 

It will be great if you could share your solution, if you got any

 

thanks