com.mysql.jdbc.MysqlDataTruncation

Data truncation: Incorrect date value: '1989-00-21' for column 'column_' at row 1

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web204

  • via GitHub by rhauch
    ,
  • via GitHub by tigerw
    ,
  • via GitHub by TheStriker0995
    ,
  • Stack trace

    • com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '1989-00-21' for column 'column_' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:888) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:730) at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest$6.execute(BinaryLogClientIntegrationTest.java:368) at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest$6.execute(BinaryLogClientIntegrationTest.java:356) at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest$MySQLConnection.execute(BinaryLogClientIntegrationTest.java:900) at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest.writeAndCaptureRow(BinaryLogClientIntegrationTest.java:356) at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest.testDeserializationOfDATE(BinaryLogClientIntegrationTest.java:258)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    aidoanaidoan
    3 times, last one
    KialandeiKialandei
    12 times, last one
    Unknown visitor
    Unknown visitor2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    pulse00pulse00
    Once,
    21 more bugmates