com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
来源:互联网 发布:数据库系统开发 编辑:程序博客网 时间:2024/06/05 01:14
情况:使用Jfinal框架时,更新用户信息,where条件中有一个字符串,没有加引号引起这个错误。
Db.update("update s_user set password='"+userPwd+"',update_time='"+DateUtil.getNowTimestamp()+"' where mobile="+mobile);
后来修改:
Db.update("update s_user set password='"+userPwd+"',update_time='"+DateUtil.getNowTimestamp()+"' where mobile='"+mobile+"'");
就可以了
一般出现这种情况有:
第一,方法重载问题
第二,字符超过了长度
第三,就是编码问题(重要,容易被人忽略)
有两种可能,第一种就是数据库编码,另外一种数据库编码没问题,文件编码有问题
阅读全文
0 0
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorr
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value:
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Exception in thread "main" com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too lo
- Eexception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PIC' at
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' a
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at r
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column MenuGrpCode at row 1
- navMesh自动寻路
- lintcode/leetcode由易至难第12题:Majority Element
- Lock使用
- excel判断某一列中的数据是否在另一列中(含跨sheet)
- bootstrap datepicker日期插件汉化
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- uptime 简介
- Linux /etc/profile文件详解
- python内存管理机制
- POI+Struts2+maven excel 导出数据
- redis 3.2.8 安装
- gradle库复制并重命名jar包
- SpringMVC注解详解
- 在eclipse中使用python