For whatever reason my app has decided to start through SQLExceptions when encountering NULL dates and datetimes. I know that this is intentional as per the driver however I also found a way to tell MySQL to convert zero dates to null. On the connection
String you can add:
zeroDateTimeBehavior=convertToNull
In DBVisualizer adding this to the connection string actually works. When I would normally get errors in its console I know longer get those errors. However, in my web application I am still getting the exception. I'm just curious if anyone else has ran into this issue and how they resolved it (other than not allowing null dates).