上傳圖片失敗 這個報錯是圖片太大？看不太懂...求大佬
服務(wù)器啟動,等待客戶端連接
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fcontent' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
at com.socket.service.FileService.save(FileService.java:26)
at com.socket.socket.ServerThread.execute(ServerThread.java:66)
at com.socket.socket.ServerThread.run(ServerThread.java:31)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fcontent' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
at com.socket.service.FileService.save(FileService.java:26)
at com.socket.socket.ServerThread.execute(ServerThread.java:67)
at com.socket.socket.ServerThread.run(ServerThread.java:31)
2018-10-09
在MySQL中有四種Blob類型，他們的區(qū)別就是可以容納的信息量不容分別是以下四種:
1.TinyBlob類型? 最大能容納255B的數(shù)據(jù)
2.Blob類型? 最大能容納65KB的
3.MediumBlob類型? 最大能容納16MB的數(shù)據(jù)
4.LongBlob類型? 最大能容納4GB的數(shù)據(jù)
很有可能是圖片太大了，Blob容納不了，可以換成MediumBlob類型，親測有效。
2017-12-26
去數(shù)據(jù)庫把fcontent字段長度改長一點試試