Java JDBC - zhongjiajie/zhongjiajie.github.com GitHub Wiki

Java-JDBC

FAQ

'0000-00-00 00:00:00' can not be represented as java.sql.Timestamp error

如果timestamp中有非法的值，如'0000-00-00 00:00:00'使用java.sql.Timestamp时会出现转化的情况，这时可以在java-jdbc链接中增加zeroDateTimeBehavior=convertToNull实现将其转化成空处理。完成的JDBC如下jdbc:mysql://yourserver:3306/yourdatabase?zeroDateTimeBehavior=convertToNull，详情参考这里

zhongjiajie's wiki is a site share my personal note.

⚠️ **GitHub.com Fallback** ⚠️