com.mysql.jdbc.MysqlDataTruncation

Data truncation: Data too long for column 'city' at row 1

Solutions on the web293

  • via journaldev.com by Unknown author, 10 months ago
    Data truncation: Data too long for column 'city' at row 1
  • via journaldev.com by Unknown author, 1 year ago
    Data truncation: Data too long for column 'city' at row 1
  • via Stack Overflow by jspking
    , 1 year ago
    Data truncation: Data too long for column 'data' at row 1
  • Stack trace

    • com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'city' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2939) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440) at com.journaldev.jdbc.transaction.EmployeeJDBCInsertExample.insertAddressData(EmployeeJDBCInsertExample.java:45) at com.journaldev.jdbc.transaction.EmployeeJDBCInsertExample.main(EmployeeJDBCInsertExample.java:23)

    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

    Once, 2 months ago
    Once, 3 months ago
    Unknown user
    Once, 5 months ago
    Once, 11 months ago
    Once, 11 months ago
    21 more bugmates