头像上传报错

天啦噜

头像上传的时候报错
报错信息如下

1. 2017-03-10 14:17:17 excute stream action, params:{process=/SA/OPM/organization/organizationProcess, activity=mainActivity, action=blobUpdateAction, parameters={blobConceptValue=N1HsiVAXMKJ07u4VdsH, blobData=java.io.ByteArrayInputStream@198dff4, blobConcept=SA_OPPerson, limitSize=1m, blobDataModel=/system/data, blobRelation=sPhoto, blobLastModifiedRelation=sPhotoLastModified}}
   
2. java.lang.reflect.InvocationTargetException
   
3.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
4.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
5.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
6.         at java.lang.reflect.Method.invoke(Method.java:497)
   
7.         at com.justep.system.action.Engine.invokeActions(Native Method)
   
8.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
9.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
10.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
11.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
12.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
13.         at com.justep.business.server.BusinessServer.excuteMultipartAction(Unknown Source)
    
14.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
15.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
16.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
17.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
18.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
19.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
20.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
21.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
22.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
23.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
24.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
25.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
26.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
27.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
28.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
29.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
30.         at java.lang.Thread.run(Thread.java:745)
    
31. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update SA_OPPerson c_ set c_.sPhoto = :blobData ,c_.sPhotoLastModified = :blobLastModified  where c_=:id
    
32.         at com.justep.exception.BusinessException.create(Unknown Source)
    
33.         at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
    
34.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
    
35.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
    
36.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
    
37.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
    
38.         at com.justep.system.data.BlobUtils.update(Unknown Source)
    
39.         at BlobProcedure.update(BlobProcedure.java:21)
    
40.         ... 28 more
    
41. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: UPDATE SA_OPPerson SET SA_OPPerson.SPHOTO =  ? , SA_OPPerson.SPHOTOLASTMODIFIED =  ?   WHERE SA_OPPerson.sID =  ? , binds: [java.io.ByteArrayInputStream@198dff4, 2017-03-10 14:17:17.367, N1HsiVAXMKJ07u4VdsH]出错
    
42.         at com.justep.exception.BusinessException.create(Unknown Source)
    
43.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
    
44.         ... 35 more
    
45. Caused by: java.sql.SQLException: Incorrect string value: '\xFF\xD8\xFF\xE0\x00\x10...' for column 'SPHOTO' at row 1
    
46.         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
    
47.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    
48.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    
49.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    
50.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    
51.         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    
52.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    
53.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    
54.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    
55.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    
56.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    
57.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    
58.         ... 36 more

复制代码

jishuang

http://www.th7.cn/db/mysql/201411/81407.shtml

天啦噜

jishuang 发表于 2017-3-10 15:02
http://www.th7.cn/db/mysql/201411/81407.shtml

照着方法改了，结果还是报错

jishuang

报错可以到网上查找其他的方案，这个就是数据库的标准报错

天啦噜

jishuang 发表于 2017-3-10 17:22
报错可以到网上查找其他的方案，这个就是数据库的标准报错

我有一个论坛账号是天啦噜404。为什么现在登录不了了

jishuang

查看状态是正确的，不能登录什么提示？

天啦噜

jishuang 发表于 2017-3-10 17:42
查看状态是正确的，不能登录什么提示？

就是密码怎么输入都不对，而且QQ登录也不行

jishuang

密码已重置为123456，请自行登录后修改

天啦噜404

jishuang 发表于 2017-3-10 17:48
密码已重置为123456，请自行登录后修改

谢谢，结贴吧，我在慢慢找方法

天啦噜404

天啦噜404 发表于 2017-3-10 17:51
谢谢，结贴吧，我在慢慢找方法

已经解决了，比对能上传成功的X5，然后用MySQL图形化界面工具修改就好，存储照片字段的类型为longblob，编码不用动