Value '0000-00-00' can not be represented as java.sql.Date

[Eder Jorge]

This happens when connecting to mysql, because mysql considers 0000-00-00
as a valid date and java.sql.Date doesn't.

To fix it, add a ?zeroDateTimeBehavior=convertToNull to your jdbc url
connection, and this value for date will be null and valid for Java.

i.e.: jdbc:mysql://<host>:<port3306>/<database>?zeroDateTimeBehavior=convertToNull</database></port3306></host>

Cheers,
Eder

[PAscal]

thanks for the tip
it seems vere similar to an old post here
https://sourceforge.net/p/sqleo/discussion/general/thread/8dcc6258/?limit=25#16ee

[Eder Jorge]

My bad, it is really the same solution. :-(. I've made a search and didn't look right all the results.
You can delete if you want.
Eder