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
Cheers, Eder
Anonymous
You seem to have CSS turned off. Please don't fill out this field.
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
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
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
Cheers,
Eder
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
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