unable to cast from java.lang.integer to java.lang.bigdecimal

[harishbabul.y]

when i am running the report with stored procedure report is running fine. in that  report there are several expressions.

due to performance issues i converted sp to sql code , now same code when i am running in jaspersoft studio , while reading the fields its showing an error

 

Error: cannot cast from java.lang.integer to java.lang.bigdecimal.

please suggest me any one

 

Best Regards,

Harish.

 

[hozawa]

There's not java.lang.integer nor java.lang.bigdecimal. Java is case sensitive so it should be java.lang.Integer and java.lang.BigDecimal.

It's just saying there's a Integer column that's being used in BigDecimal expression.