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

GitHub | nathandunn | 5 months ago
  1. 0

    mysql error when getting timestamps

    GitHub | 5 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 | 1 year 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 | 6 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 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