java.sql.SQLException: Value 2009-02-25 07:51:54.2730000 +00:00 cannot be converted to TIMESTAMP.

Stack Overflow | phani | 4 months ago
  1. 0

    Why is jTDS failing to convert SQL Server datetime to java.sql.timestamp?

    Stack Overflow | 4 months ago | phani
    java.sql.SQLException: Value 2009-02-25 07:51:54.2730000 +00:00 cannot be converted to TIMESTAMP.
  2. 0

    getTimestamp throws an exception

    jtds | 10 years ago | meken
    java.sql.SQLException: Unable to convert between [B and TIMESTAMP.
  3. 0

    handling DATETIME values 0000-00-00 00:00:00 in JDBC

    Stack Overflow | 8 years ago | Jason S
    java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate | The Error Message

    theerrormessage.com | 1 year ago
    org.hibernate.exception.GenericJDBCException: could not execute query
  6. 0

    MySQL Bugs: #19274: failure to convert datetime '0000-00-00 00:00:00' to TIMESTAMP

    mysql.com | 2 months ago
    java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP.

    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 2009-02-25 07:51:54.2730000 +00:00 cannot be converted to TIMESTAMP.

      at net.sourceforge.jtds.jdbc.Support.convert()
    2. jTDS
      JtdsResultSet.getTimestamp
      1. net.sourceforge.jtds.jdbc.Support.convert(Support.java:516)[jtds-1.3.1.jar:1.3.1]
      2. net.sourceforge.jtds.jdbc.JtdsResultSet.getTimestamp(JtdsResultSet.java:1182)[jtds-1.3.1.jar:1.3.1]
      3. net.sourceforge.jtds.jdbc.JtdsResultSet.getTimestamp(JtdsResultSet.java:1334)[jtds-1.3.1.jar:1.3.1]
      3 frames
    3. Hibernate
      Loader.getRowFromResultSet
      1. org.hibernate.type.descriptor.sql.TimestampTypeDescriptor$2.doExtract(TimestampTypeDescriptor.java:76)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      2. org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      3. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      4. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:234)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      5. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:224)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      6. org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:300)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      7. org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2727)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      8. org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1729)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      9. org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1655)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      10. org.hibernate.loader.Loader.getRow(Loader.java:1544)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      11. org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:727)[hibernate-core-5.0.9.Final.jar:5.0.9.Final]
      11 frames