Getting error in date field while generating report

0

Hi,

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
21
Joined: Apr 28 2015 - 4:46am
Last seen: 3 years 11 months ago

1 Answer:

0

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

hozawa's picture
47107
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 months 2 weeks ago
Feedback