Error Convert Fields

[2006 IR Open Dicussion]

By: geraldine84 - geraldine84

Error Convert Fields

2006-02-15 07:33

When compiling my report, I get an error

 

java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Value can not be converted to requested type.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseData.getDouble(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.getDouble(Unknown Source)

at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:156)

at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1217)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:780)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163)

at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:626)

at java.lang.Thread.run(Unknown Source)

 

NESTED BY :

java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Value can not be converted to requested type.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseData.getDouble(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.getDouble(Unknown Source)

at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:156)

at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1217)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:780)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163)

at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:626)

at java.lang.Thread.run(Unknown Source)

 

NESTED BY :

net.sf.jasperreports.engine.JRException: Unable to get value for field 'r_rew_Ym4RewVal' of class 'java.lang.Double'

at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:311)

at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1217)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:780)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163)

at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:626)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Value can not be converted to requested type.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseData.getDouble(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.getDouble(Unknown Source)

at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:156)

... 9 more

 

After many tests, I saw that all errors were on fields which are float un database, with size of 4.

All fields with float, size 8 or double size 8 work, but not float size 4. Do somebody knows why?

 

Thanks and sorry for my approximative english

 

 

 

 

By: geraldine84 - geraldine84

RE: Error Convert Fields Urgent!

2006-02-16 01:41

Please, it is urgent, did somebody get the same pb?