Iam generating a simple report in jasper studio and im using mysql database.
I have a date field in mysql it is in Current_Timestamp.
But during ETL process some fields are filled with (0000-00-00 00:00:00) when i run the report it will give "Unable to get value for field 'date' of class 'java.sql.Timestamp" error.
Can anyone help me please??
Thanks in advance.
Posted on August 18, 2015 at 9:26pm
Fix your database table to default date to the current date/time.