13:00:32.666 DEBUG (NutDaoExecutor.java:388) printSQL - INSERT INTO t_user(id,name,passwd,salt,locked,ct,ut) VALUES(?,?,?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|-------|------------------------------------------------------------------|----------------------------------|-------|---------------------|---------------------|
| 2 | admin | dcddb07e8e82fef1a8726fdc0e6cd2e15886782cf0a17b86801c19014b667cc3 | 90b9330b80994a58b1a1edf428b340b8 | false | 2016-11-22 13:00:32 | 2016-11-22 13:00:32 |
For example:> "INSERT INTO t_user(id,name,passwd,salt,locked,ct,ut) VALUES(2,'admin','dcddb07e8e82fef1a8726fdc0e6cd2e15886782cf0a17b86801c19014b667cc3','90b9330b80994a58b1a1edf428b340b8',false,'2016-11-22 13:00:32','2016-11-22 13:00:32') "
13:00:32.677 DEBUG (NutDaoExecutor.java:97) exec - SQLException
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'passwd' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3964) ~[mysql-connector-java-5.1.39.jar:5.1.39]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) ~[mysql-connector-java-5.1.39.jar:5.1.39]
6 回复
@wendal 是的,昨天刚fetch的
@wendal 新建数据库nutzbook,堆编码的要求是? utf8mb4、utf8mb4_unicode_ci 可以吧?
@wendal 生成的t_user.passwd表字段的长度是50,而插入sql要求128
找到原因了 https://github.com/nutzam/nutz/commit/8b5ced8d287ed35c15e8f9e618666bb09f9b3ef5
更新一下maven的库吧, maven --> update project --> force update
添加回复
请先登陆