部署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
创建数据库的时候指定编码即可;
CREATE DATABASE IF NOT EXISTS jeecg DEFAULT CHARSET utf8 COLLATE utf8_general_ci; 看错误是编码问题
页:
[1]