Getting error in date field while generating report


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.


manoj.p's picture
Joined: Apr 28 2015 - 4:46am
Last seen: 7 years 8 months ago

1 Answer:

Fix your database table to default date to the current date/time.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago