Getting error in date field while generating report

Posted on August 18, 2015 at 9:20pm

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.

 

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

1 Answer:

Posted on August 18, 2015 at 9:26pm

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

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