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

  1. ,
    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 YouTrack by Unknown author, 2 years ago
Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
via GitHub by nathandunn
, 1 year ago
Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
via Stack Overflow by karthi keyan
, 1 year ago
via GitHub by SmithJiong
, 2 years ago
Operation not allowed after ResultSet closed
via Stack Overflow by david90
, 2 years ago
via Google Groups by Yonah, 10 months ago
Value '0000-00-00' can not be represented as java.sql.Date
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.grails.datastore.gorm.GormStaticApi$_methodMissing_closure2.doCall(GormStaticApi.groovy:102)	at org.bbop.apollo.PreferenceService.$tt__getCurrentOrganismPreference(PreferenceService.groovy:130)	at org.bbop.apollo.PreferenceService.$tt__getOrganismFromPreferences(PreferenceService.groovy:173)	at org.bbop.apollo.PreferenceService.$tt__getCurrentOrganismForCurrentUser(PreferenceService.groovy:17)	at org.bbop.apollo.SequenceController.$tt__getSequences(SequenceController.groovy:165)	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 org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)	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)