mysql5.1 2530_'新手入门'中更新头像报错与mysql版本有关吗

最新推荐文章于 2021-03-23 12:28:43 发布

村口王二狗

最新推荐文章于 2021-03-23 12:28:43 发布

阅读量106

点赞数

文章标签： mysql5.1 2530

本文链接：https://blog.csdn.net/weixin_33841242/article/details/114339983

版权

问题现象：

1. 我用的mysql 5.0.18-nt,驱动用的mysql-connector-java-5.1.34.jar

2. 涉及的代码

profile.setAvatar(new SimpleBlob(tf.getFile()){

public byte[] getBytes(long pos, int length) throws SQLException {

if (pos == 1 && length == length())

try {

return Streams.readBytes(getBinaryStream());

} catch (IOException e) {

}

return super.getBytes(pos, length);

}

});

dao.update(profile, "^avatar$");

3. 下面是报错信息：

2015-10-13 22:40:11,027 org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:276) DEBUG - batch acquisition of 0 triggers

2015-10-13 22:40:24,860 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90) DEBUG - SQLException

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'þì?‘ÿ\0Åi{SL¦ŽDEÍÏí‰¿»äÆ�í‰û,?‘ÿ\0ÄdÓóO•scûbîÃùñ§

^cü1~Gük&ª^j¶Ön±ÈònN' at line 1

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)

at com.mysql.jdbc.Util.getInstance(Util.java:360)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)

at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)

at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:266)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:81)

at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:264)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:64)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:219)

at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)

at org.nutz.dao.impl.NutDao.update(NutDao.java:265)

at org.nutz.dao.impl.NutDao$5.run(NutDao.java:279)

at org.nutz.dao.FieldFilter.run(FieldFilter.java:285)

at org.nutz.dao.impl.NutDao.update(NutDao.java:282)

at com.just.platform.module.UserProfileModule.uploadAvatar(UserProfileModule.java:121)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)