附件组件上传报错，ksql执行插入文档数据异常。

boolean

当我上传超过10M的文件时，报异常
Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO SA_DocLog (SA_DocLog.sID, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.SDOCNAME, SA_DocLog.sDocVersionID, SA_DocLog.SSIZE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[601E010AE7BE4AB799BC98A24992FED4, 0, C5E27E4A8C9000017F5011DB6B401887, /750E6E1B1E6A4F0FB9E94969709463CE.ogn/6B8523C02A634EBE932AACDED2444027.dpt/1CFF90570AD74D6097FD76E23323DE04@6B8523C02A634EBE932AACDED2444027.psm, 赖进科, null, 2013-10-16 11:02:37.459, new, X5.2.5快速开发指南.pdf, 1, 1.4434951E7]出错！
    at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
    ... 40 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'sSize' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    ... 41 more

jishuang

SA_DocLog 中sSize字段的长度设置大点

boolean

jishuang 发表于 2013-10-16 11:25
SA_DocLog 中sSize字段的长度设置大点

OK 解决了

boolean

jishuang 发表于 2013-10-16 11:25
SA_DocLog 中sSize字段的长度设置大点

对了 还有个问题 就是我设置了组件的文档子目录sub-path 但是还是保存在根目录下了 怎么回事啊？