com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 2

journaldev.com | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    JDBC Batch insert update MySQL Oracle - JournalDev

    journaldev.com | 7 months ago
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 2
  2. 0

    Data too long for column mysql

    Stack Overflow | 2 years ago
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'odlukaKomentar' at row 1

    Root Cause Analysis

    1. com.mysql.jdbc.MysqlDataTruncation

      Data truncation: Data too long for column 'name' at row 2

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      PreparedStatement.executeBatch
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2939)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
      4. com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
      5. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
      6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
      7. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
      8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
      9. com.mysql.jdbc.PreparedStatement.executeBatchedInserts(PreparedStatement.java:1008)
      10. com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:908)
      10 frames
    3. com.journaldev.jdbc
      JDBCBatchExceptions.main
      1. com.journaldev.jdbc.batch.JDBCBatchExceptions.main(JDBCBatchExceptions.java:37)
      1 frame