error: unable to get field value

[mtassinari]

Hi everybody,

I've just encountered this problem: while trying to compile a report I'm getting this error

javax.servlet.ServletException: net.sf.jasperreports.engine.JRException: Unable to get value for field 'data_ultima_revisione' of class 'java.sql.Date'

The strange thing is that nowhere in my report there is a field named "data_ultima_revisione", nor is it present in a query.

Could the problem happen if I have a "SELECT *" in a query, and the field data_ultima_revisione is declared as "date" on the database but has an invalid value? Even if the field is not list in the report fields list?

 

Thanks in advance for your help.

[drummer54]

I'm having the same problem, with a date field in a MySQL database.  I filtered out the null values to determine if that was the problem but am still getting the error.  In MySQLWorkbench an example of a value in the problem field is '1962-06-03'.  Why would that be a problem for JasperReports?

[djohnson53]

mtassinari,

Seems like you answered your own question. The field, data_ultima_revisione, you mentioned does not match a Jasper namespace. Try select the particular fields you need and not "select * " and see if the error goes away.

mmatassa,

You don't have the same problem and should probably post your own question. Riders like this usually don't get good response.

Good Luck to both of you.

[dev_34]

Similar problem?

-> https://community.jaspersoft.com/questions/1116991/unable-get-value-excel-field-classlangstring