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

GitHub | nathandunn | 8 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    mysql error when getting timestamps

    GitHub | 8 months ago | nathandunn
    java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
  2. 0

    Error retrieving last seen timestamp

    GitHub | 2 years ago | daniele-athome
    tigase.db.TigaseDBException: Problem loading user info from repository
  3. 0

    Getting the exception like "Cannot convert value '0000-00-00 00:00:00' from column 12 to TIMESTAMP"

    Stack Overflow | 7 years ago | Rakesh Sabbani
    java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 12 to TIMESTAMP.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL exception launching RDFizer

    GitHub | 2 years ago | scanbit
    org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [S1009]; error code [0]; Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP.; nested exception is org.hibernate.exception.GenericJDBCException: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP.
  6. 0

    How to deal with "Value '0000-00-00' can not be represented as java.sql.Timestamp" error at application level?

    Stack Overflow | 2 years ago | Dave A
    javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not read entity state from ResultSet : EntityKey[org.mainco.subco.mypackage.domain.mypackage#BELVUEADMINTESTLP1]

  1. DoktorDoener666 1 times, last 3 weeks ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

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

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    ResultSetImpl.getTimestamp
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
    5. com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1101)
    6. com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:126)
    7. com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6588)
    8. com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6188)
    9. com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6226)
    9 frames
  3. Grails GORM
    GormStaticApi$_methodMissing_closure2.doCall
    1. org.grails.datastore.gorm.GormStaticApi$_methodMissing_closure2.doCall(GormStaticApi.groovy:102)
    1 frame
  4. org.bbop.apollo
    SequenceController.$tt__getSequences
    1. org.bbop.apollo.PreferenceService.$tt__getCurrentOrganismPreference(PreferenceService.groovy:130)
    2. org.bbop.apollo.PreferenceService.$tt__getOrganismFromPreferences(PreferenceService.groovy:173)
    3. org.bbop.apollo.PreferenceService.$tt__getCurrentOrganismForCurrentUser(PreferenceService.groovy:17)
    4. org.bbop.apollo.SequenceController.$tt__getSequences(SequenceController.groovy:165)
    4 frames
  5. grails.plugin.cache
    AbstractFilter.doFilter
    1. grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198)
    2. grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
    2 frames
  6. Shiro
    OncePerRequestFilter.doFilter
    1. org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
    2. org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
    3. org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
    4. org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
    5. org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
    6. org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
    7. org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
    7 frames
  7. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames