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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

Solutions on the web

via GitHub by nathandunn
, 1 year ago
Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
via YouTrack by Unknown author, 1 year ago
Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
via Google Groups by Yonah, 5 months ago
Value '0000-00-00' can not be represented as java.sql.Date
via GitHub by Akegata
, 10 months ago
Value '563iny Tiny RSS: New Releases�http://tt-rss.org/releases.rss000000-00-00 00:00:00�00010000�2013-04-29 20:30:010000000��' can not be represented as java.sql.Timestamp
via GitHub by chatainsim
, 2 years ago
Value '1022iny Tiny RSS: New Releases�http://tt-rss.org/releases.rss000000-00-00 00:00:00�0001000�2014-12-01 13:37:420000000�0�' can not be represented as java.sql.Timestamp
java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1101)
at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:126)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6588)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6188)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6226)
at org.bbop.apollo.PreferenceService.$tt__getCurrentOrganismPreference(PreferenceService.groovy:130)
at org.bbop.apollo.PreferenceService.$tt__getCurrentOrganismPreference(PreferenceService.groovy:181)
at org.bbop.apollo.AnnotatorService.$tt__getAppState(AnnotatorService.groovy:46)
at org.bbop.apollo.AnnotatorController.$tt__getAppState(AnnotatorController.groovy:371)
at grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198)
at grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Once, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 2 months ago
3 times, 12 hours ago
16 times, 5 days ago
164 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.