liaoyuanyekong 发表于 2013-12-14 15:35:50

部署jeecg v3.0时候update数据出现了问题

部署jeecg v3.0时候插入出现了问题,请各位帮忙看下。现在用的mysql5.5 表都建好了但是插入数据出了问题。一开始用oracle插入也有问题。现在换了mysql还是有问题


Caused by: java.sql.SQLException: Incorrect string value: '\xE5\xB8\xB8\xE7\x94\xA8...' for column 'functionname' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2717)
        at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1052)
        at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2715)
        at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:106)
        at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:237)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
        ... 49 more
2013-12-14 15:27:35 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
2013-12-14 15:27:35 org.apache.catalina.core.StandardContext start
严重: Context startup failed due to previous errors
2013-12-14 15:27:35 org.apache.catalina.core.ApplicationContext log
信息: Closing Spring root WebApplicationContext

guoping 发表于 2014-2-15 21:30:48

创建数据库的时候指定编码即可;
CREATE DATABASE IF NOT EXISTS jeecg DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

IQ10 发表于 2014-2-16 23:49:29

看错误是编码问题
页: [1]
查看完整版本: 部署jeecg v3.0时候update数据出现了问题