JDBC Connection Mysql,tomcat Error: Cannot convert value ' 0000-00-00 00:00:00 ' from column ten to TIMESTAMP

The solution is based on the following URL:

http://blog.csdn.net/stail111/article/details/5640109

Questions: MySQL database, if the date character blank in the database is a value of ' 0000-00-00 00:00:00 ' when queried, return: Cannot convert value ' 0000-00-00 00:00:00 ' from column TIMESTAMP

Workaround:

Change the way you connect to a database

Add a parameter after the connection: Jdbc:mysql://127.0.0.1:3306/test Zerodatetimebehavior=converttonull

That is, change to:

Jdbc:mysql://127.0.0.1:3306/test?zerodatetimebehavior=converttonull

The problem is solved.

Online to see a good answer URL: http://www.bennadel.com/blog/1434- Mysql-cannot-convert-value-0000-00-00-00-00-00-from-column-xx-to-timestamp.htm

JDBC Connection Mysql,tomcat Error: Cannot convert value ' 0000-00-00 00:00:00 ' from column ten to TIMESTAMP