com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'city' at row 1

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via journaldev.com by Unknown author, 1 year 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 Jive Software Open Source by wroot, 1 year ago
Data truncation: Data too long for column 'subject' at row 1
via Jive Software Open Source by wroot, 1 year ago
Data truncation: Data too long for column 'subject' at row 1
via JIRA by wroot, 1 year ago
Data truncation: Data too long for column 'subject' at row 1
via coderanch.com by Unknown author, 2 years ago
Data truncation: Incorrect datetime value: '25-apr-2013' for column 'Time' at row 1
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.EmployeeJDBCTransactionExample.main(EmployeeJDBCTransactionExample.java:19)

Users with the same issue

2 times, 1 year ago
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 9 months ago
Once, 1 week ago
23 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.