About database Timestamp type issues

The database uses the timestamp Type field, with the default time being 0000-00-00 00:00:00

So backstage will be reported Java.sql.SQLException:Value ' 0000-00-00 00:00:00 ' can not be represented as Java.sql.Timestamp error!

This is because MySQL 0000-00-00 00:00:00 seems to have a special meaning so java.sql.Date would think it's an illegal value format is incorrect

So I'm going to report this mistake.

Solution: Add zerodatetimebehavior=converttonull to the database link address

Example: jdbc:mysql://127.0.0.1:3306/lover2?autoreconnect=true&useunicode=true&characterencoding= UTF-8&zerodatetimebehavior=converttonull

Problem Solving!!

About database Timestamp type issues