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

by

You can use this JDBC URL directly in your data source configuration:

jdbc:mysql://yourserver:3306/yourdatabase?zeroDateTimeBehavior=convertToNull

More Related Contents:

  1. Handling MySQL datetimes and timestamps in Java
  2. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  3. Hours and seconds are lost when storing a date in the database [closed]
  4. Multiple queries executed in java in single statement
  5. Java: Insert multiple rows into MySQL with PreparedStatement
  6. Using “like” wildcard in prepared statement
  7. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  8. MySQL and JDBC with rewriteBatchedStatements=true
  9. Closing JDBC Connections in Pool
  10. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  11. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  12. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  13. Returning a ResultSet
  14. How to change MySQL timezone in a database connection using Java?
  15. How to configure Tomcat to connect with MySQL
  16. Retrieve an Image stored as BLOB on a MYSQL DB
  17. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  18. mysql prepared statement error: MySQLSyntaxErrorException
  19. how to get list of Databases “Schema” names of MySql using java JDBC
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. Access denied for user ‘root’@’localhost’
  22. How to correctly write UTF-8 strings into MySQL through JDBC interface
  23. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  24. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  25. java.sql.SQLException: Before start of result set [duplicate]
  26. How to use prepared statement for select query in Java?
  27. Stumped SQL Exception for JDBC
  28. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  29. How to connect to a remote MySQL database with Java?
  30. A persistent connection with JDBC to MySQL

Leave a Comment